How do you look up Name by using VLOOKUP, thru another worksheet.
L L. Howard Kittle Jun 15, 2005 #2 Hi Cindy, If I understand correctly something like this perhaps. =VLOOKUP(B1,Sheet2!A1:B4,2,0) Where B1 is on sheet 1 and the lookup array A1:B4 is on sheet two. HTH Regards, Howard
Hi Cindy, If I understand correctly something like this perhaps. =VLOOKUP(B1,Sheet2!A1:B4,2,0) Where B1 is on sheet 1 and the lookup array A1:B4 is on sheet two. HTH Regards, Howard
