Query to Return Value from Seperate Worksheet

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
 
V

vezerid

Sean,
use VLOOKUP. In Worksheet1!B2:

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

HTH
Kostis Vezerides
 
G

Guest

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-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying the last used cell only 4
Need formula or macro 2
trigger worksheet activate event in another worksheet 2
Index match with multiple criteria(different than usual) 3
Paste into next blank row in a different worksheet 10
Using cell value to reference another cell 2
Need help comparing & flagging email lists in separate worksheets 5
copy latest price from sheet1 to sheet2 using VBA 4

Top