vlookfunction help

[Igneshwara reddy]

Hi,

I am using vlookup for the below data and looking for answers "Old" or "New"

Data Old vlookup formula
123 123 =vlookup(A2,B2:B4,1,0) results in answer as 123.
12345 3456
3456 34566
34566 12345
6545

Whenever the data matches it should result the answer as "OLD" instead of
123 and if it is not found the answer to be as "NEW.

Please help me with the formula.

Regards,
Igneshwara Reddy

 

[Mike H]

Hi,

=IF(ISNA(MATCH(A2,B2:B6)),"New","Old")

Mike

 

[Mike H]

corection

=IF(ISNA(MATCH(A2,B2:B6,0)),"New","Old")

Mike

 

[Lars-Åke Aspelin]

Hi,

I am using vlookup for the below data and looking for answers "Old" or "New"

Data Old vlookup formula
123 123 =vlookup(A2,B2:B4,1,0) results in answer as 123.
12345 3456
3456 34566
34566 12345
6545

Whenever the data matches it should result the answer as "OLD" instead of
123 and if it is not found the answer to be as "NEW.

Please help me with the formula.

Regards,
Igneshwara Reddy

Try this formula:

=IF(ISNA(MATCH(A2,B$2:B$100,0)),"NEW","OLD")

Change the 100 to fit the size of your data in column B.

Hope this helps / Lars-Åke

 

[Teethless mama]

=IF(COUNTIF(B2:B4,A2),"old","new")