Pete thank you for your help. I have been looking at VLOOKUP and have tried
to make it work but my knowledge on this formula is lacking. Will the
formula work even if the the value isn't always in the same possition or cell
on the spreadsheet. Would it be possible to get an explanation on the
mechanics or the different items listed after VLOOKUP in the cell. I could
forward to you an example if that would help.

"Pete_UK" wrote:

You would normally use VLOOKUP for this. Assuming your values are in
columns A and B, then put this in B1 of Sheet1:

=VLOOKUP(A1,Sheet2!A:B,2,0)

then copy it down. If there is a match, you will get the data from the
adjacent column, but with no match you will get #N/A.

Hope this helps.

Pete

On Nov 16, 10:40 pm, FER wrote:
I work with spreadsheets that have multiple tabs. I need to search one tab
and after locating the value return the value in the cell next to current tab.

tab 1 will be tab 2
cond cond 123
furn furn 456
cl cl 789