Thread: Lookup across multiple columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Lookup across multiple columns
I'd start at Debra Dalgleish's site:
http://contextures.com/xlFunctions03.html


wrote:

Hi there,

I have a big list of data, across multiple columns. I need a formula
that search a specific value that is sitting in column X. If found, it
should return the value that is on the same row in column H.
The data can be found on the left side of column H (A-G) or on the
right side of column H (I-W).

Appreciate your help.

--

Dave Peterson
Reply With QuoteReply With Quote