| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
return a range of cells from a vertical lookup
I would like to know if I can return a range of cells (up to 30 columns to
the right of the lookup) when using vertical lookup forula????? |
|
#2
|
|||
|
|||
|
To the best of my knowledge, VLOOKUP only returns one value.
"vickyb_au" wrote in message ... I would like to know if I can return a range of cells (up to 30 columns to the right of the lookup) when using vertical lookup forula????? |
|
#3
|
|||
|
|||
|
use array VLOOKUP
the formula looks like : =VLOOKUP([key],[find in range],{2,3,4,...,31},0) suppose you the VLOOKUP result in A10:AD10. So select A10:AD10, type the formula above, press Ctrl+Shift+ENTER. "vickyb_au" wrote: I would like to know if I can return a range of cells (up to 30 columns to the right of the lookup) when using vertical lookup forula????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| monitoring a changing range of cells | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Linear Mode
