View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fer Fer is offline
external usenet poster
 
Posts: 5
Default How to search a spread sheet for a value and return the adjacent v

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