Crossreferencing

Closed
Report
-
 Trowa -
Hello,
Heres my question. I have 2 sheets in excel, the first sheet has names in one collum and numbers in another collum. What i need to do is in the second sheet, when i enter one of the names the corresponding number has to get plugged into the cell next to it.

ive tried the search function on cell C6: =search(B6, 'sheet1'!B:B, 'sheet1'!C:C)

i thought that that looked fine... it reads the name in B6 (sheet 2), searches the B collum on sheet 1 for that name and returns the value of corresponding C cell of the first sheet.....

plz help :)

(using excel 2003)

1 reply

You are looking for VLOOKUP.

Sheet 2 Cell C6:
=VLOOKUP(B6,Sheet1!B1:C100,2)

Look for value in B6,
Look in sheet 1 range B1:C100, (change range if nessecary)
Take the value of the 2nd column.

Best regards,
Trowa