Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of IDs that I'm performing a vlookup on. But in order to save
space I don't want to list out all of the results of the vlookup. So I did a single-cell array for the vlookup on the IDs. {=VLOOKUP(N9:Q9,ModelData!$A:$BZ,63,FALSE)} That command appears to be working because if I expand the array, all of the results are there. But then when I do the max() of the single-cell array, it just returns the first result in the array. What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array input in one single cell | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Filling excel entire row/column instead of single cell from an array | Excel Worksheet Functions | |||
Entering array in single cell | Excel Discussion (Misc queries) | |||
Test for Single Character That is in an Array | Excel Worksheet Functions |