Need help with Lookup
 

I need help with Lookup (vector).

Lookup seems to have the function I need. But my lookup_vector and
result_vector are not the same size. So I guess I can not really use
the lookup function. Please help.

Here is my problem. I have two worksheets. The first worksheet has
columns A, B, C, D, the second worksheet has columns A', E, F, G. The
column A' has more rows than A, and all the values in A are in A'. I
need to bring the values in the columns E, F and G in the second
worksheet into the first worksheet when A matches A'.

Please advice and let me know if my description is not clear.

Fred


--
zheng4
------------------------------------------------------------------------
zheng4's Profile: http://www.excelforum.com/member.php...o&userid=35948
View this thread: http://www.excelforum.com/showthread...hreadid=557362

Need help with Lookup
 

Put in and copy down

E1=IF(A1=Sheet2!A1,VLOOKUP(A1,Sheet2!A1:G100,5,FAL SE),"")
F1=IF(A1=Sheet2!A1,VLOOKUP(A1,Sheet2!A1:G100,6,FAL SE),"")
G1=IF(A1=Sheet2!A1,VLOOKUP(A1,Sheet2!A1:G100,7,FAL SE),"")