View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shehasclass
 
Posts: n/a
Default Lookup & Return Range of Data

I have tried everything and cannot figure this out......

I need to look up text in a range of data, and when a match is found,
have Excel return the data in the 11 cells to the right of the match.
It would be best if the match cell could be returned as well (making a
total of 12 horizontal cells, e.g., A4:L4).

Example:

My formula will be entered in cell A2 of sheet 1.
My data table will be in A5:L20 of sheet 2.

Formula will say "if sheet 2 cell A5 is xxx, then return the contents
of cells A5 THROUGH L5".

I hope I am being clear. I've tried everything I can think of -
vlookup, match, index. I can't figure out how to return the data from
a range of cells. Help! Thank you.