Query to Return Value from Seperate Worksheet
 

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

Query to Return Value from Seperate Worksheet
 

Sean,
use VLOOKUP. In Worksheet1!B2:

=VLOOKUP(A2,'Worksheet2'!A:B,2,FALSE)

HTH
Kostis Vezerides

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