Referencing via VLookup

[Mizzness]

All.

How can I combine the IF function with the Vlookup function when what I am referencing is duplicated ?

In my example below referencing the bin # of the dog is easy but for the others I get a NO for an answer when clearly the bin# is there.

I know this has to do with the bin# being duplicated but am brain-dead at the moment.

Example:
Bin# Animal
1234 cat
1234 cat
1234 cat
3456 dog
4567 snake
4567 snake
4567 snake


Thank for any & all help.

 

[Lilliabeth]

=VLOOKUP(F1,A1:B7,2,FALSE)

 

[Mizzness]

Maybe I was far from being clear.

I am getting #N/A as an answer.
I beleive this is because the bin #'s are duplicated.

 

[Mizzness]

My formula is:
=IF(ISNA(VLOOKUP(C1,'[verve_NA_user_recert_Nov05.xls]Remove Access2'!$B:$C,2,FALSE)),TRUE,VLOOKUP(C1,'[verve_NA_user_recert_Nov05.xls]Remove Access2'!$B:$C,2,FALSE))

Can vlookup ignore duplicated,in my case, bin #'s ?

Thanks again.

 

[Lilliabeth]

Both the vlookup I sent to you and the formula you just posted work fine for me.

You got leading or trailing spaces in those bin#s maybe?

 

[Lilliabeth]

I should clarify: Both of them work fine for me and my sample data does have duplicate bin#s.

 

[bkpchs237]

Mizzness,
As Lilliabeth stated the formulas work fine and seem to be proper as written. The questions are:
Are you actually trying to find values that reside in columns B & C on the "Remove Access2" worksheet or are they in different columns?
Otherwise, if you believe the item you are looking for in C1 should return a value, then that item is not EXACTLY like the item in columns B & C. I suggest you test this by actually copying a value from column B and putting that into cell C1 and check thr result.

Hope this helps.