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 |