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.....
