vlookup error

[dawsonr]

Hi Everyone
I realise this is a pretty easy post, but there is something I am not doing correctly and its driving me mad!

I have on sheet 2 column A is a list of 31 product codes column B is the description of product
On sheet 1 I have a list of the same data however only have 14 of the product codes (Same A and B Column)

I wanted to do a lookup on sheet 2 in column C to show the product code is it is on sheet 1 or a "no" if it is not there. Everytime I do it, I get the values in sheet two returned?

excel.JPG=VLOOKUP(A2,'Sheet 2'!A2:B20,1,FALSE)

excel.JPG

[José Augusto]

Hi
=VLOOKUP(A2,'Sheet 2'!A2:B20,1,FALSE)
Yes. You get the value of column 1 (A) in range A2:B20
If you use =VLOOKUP(A2,'Sheet 2'!A2:B20,2,FALSE) you get the value of column 2 (B) in range A2:B20

[:) Sixthsense :)]

Why not just Countif() instead of Vlookup() if your intention is to check the availability of the text.

[dawsonr]

Hi everyone, i'm still struggling to get it right, either function

[:) Sixthsense :)]

Hi everyone, i'm still struggling to get it right, either function

=IF(COUNTIF('Sheet 2'!$A$2:$B$20,A2),"Yes","No")

[dawsonr]

Hi everyone, i'm still struggling to get it right, either function

[3xe1]

Hi everyone, i'm still struggling to get it right, either function

If you can share the file (may be with dummy data), something can be done to sort it out!

[:) Sixthsense :)]

Seems like an automated message

[jwillis07]

In Sheet 2, Cell C2

=IF(COUNTIF('Sheet 1'!$A$2:$A$15,'Sheet 2'!$A2)<=0,"No",VLOOKUP('Sheet 2'!$A2,'Sheet 1'!$A$2:$B$15,1,false))