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