vlookfunction help

  • Thread starter Thread starter Igneshwara reddy
  • Start date Start date
I

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
 
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
Click to expand...


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
 
Back
Top