VLookup Function

[arcmedic]

Hi,

Quick question I have a column of data say from A2:A100 with various unique identifiers in it. I want to search through that list match it with a specific unique ID say in B2 and if the value in B2 is in that column of data return the text "Positive" or else "Negative".

I have tried Vlookup but it wants to return a row number

Anyone got any ideas.


Help as always greatly appreciated.

Thanks

[lazyme]

Please Login or Register  to view this content.

[Palmetto]

I think lazyme got the columns reversed

Should be, per your description:

=if(iserror(match(A2,$B$2:$B$100,0)),"Negative","Positive")

or, using LOOKUP as you started with:

=IF(ISNA(VLOOKUP(A2,$B$2:$B$100,2,FALSE)),"Negative","Positive")

[arcmedic]

I think lazyme got the columns reversed

Should be, per your description:

=if(iserror(match(A2,$B$2:$B$100,0)),"Negative","Positive")

or, using LOOKUP as you started with:

=IF(ISNA(VLOOKUP(A2,$B$2:$B$100,2,FALSE)),"Negative","Positive")

A billion thank you's!

I was in the middle of trying =IF(AND(MATCH(B540,U2:U100,0)=44),"Positive","Negative")

Since the value given was 44 if it existed but it would give an #N/A for the negatives. But the above solution is a god send. Thank you again.