Query to Return Value from Seperate Worksheet

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

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
 
Sean,
use VLOOKUP. In Worksheet1!B2:

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

HTH
Kostis Vezerides
 
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-
 
Back
Top