Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
how to lookup a value within a range and return a label | Excel Discussion (Misc queries) | |||
return a range of cells from a vertical lookup | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |