Vlookup

[Eman via OfficeKB.com]

Hi,
I wanted to use IF and Vlookup formula to find data from Sheet1 into Sheet2
in the same spreadsheet. I wanted the formula to look at Cells A2:A20 in
Sheet1 and in Sheet2 for match, if those information match, put the data find
in cells C2:C20 in Sheet1 into C2:C20 of Sheet2
-Something like IF('Sheet1'!A2:A20=A2:A20, Vlookup('Sheet1'!C2:C20))
-I'm using the following formula in sheet2 but it returning #VALUE!
=IF(C2="","",(VLOOKUP(Sheet1!$A$2:$D$11,3,FALSE)))

Can anyone assist me?
Thanks

 

[Don Guillett]

You need something to lookup. Perhaps you want to look up c2
=IF(C2="","",VLOOKUP(c2,Sheet1!$A$2:$D$11,3,FALSE))

 

[T. Valko]

Enter this formula on sheet2 C2:

=VLOOKUP(A2,Sheet1!A$2:C$20,3,0)

Copy down as needed

 

[Eman via OfficeKB.com]

Thanks T. Valko, It works

Best

Enter this formula on sheet2 C2:

=VLOOKUP(A2,Sheet1!A$2:C$20,3,0)

Copy down as needed

Hi,
I wanted to use IF and Vlookup formula to find data from Sheet1 into

[quoted text clipped - 9 lines]

Can anyone assist me?
Thanks

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

Thanks T. Valko, It works

Best

Enter this formula on sheet2 C2:

=VLOOKUP(A2,Sheet1!A$2:C$20,3,0)

Copy down as needed

Hi,
I wanted to use IF and Vlookup formula to find data from Sheet1 into

[quoted text clipped - 9 lines]

Can anyone assist me?
Thanks