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

--
Emmanuel K. Agbovi

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200806/1