Query to Return Value from Seperate Worksheet
you need to use vlookup:
if name column in worksheet 1 is in column A and name column in worksheet 2
is alsco columnA and number is in col. B:
in worksheet one type
=vlookup(A1,Sheet2!A:B,2,false)
you might also lookin office help how to use vlookup.
rgds-
"Sean" wrote:
Hi, I am guilty of not spening enough time looking through these
threads to find the answer however I need some quick help... I have a
worksheet, Worksheet1, that contains a Name column and a blank column
and a second worksheet, Worksheet2, that contains a Name column and a
Number column. I would like to query Worksheet2 with the name from
Worksheet1 and return the number next to the name on Worksheet2,
providing there is a name match, to the blank cell next to the Name
from Worksheet1. Thank you all in advance for your help.
Sean
|