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,

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

Mike

"Igneshwara reddy" wrote:

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

corection

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

Mike


"Mike H" wrote:

Hi,

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

Mike

"Igneshwara reddy" wrote:

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

On Sun, 30 Aug 2009 01:22:01 -0700, Igneshwara reddy
wrote:

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

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


"Igneshwara reddy" wrote:

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