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????? |
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????? |
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????? |
All times are GMT +1. The time now is 05:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com