View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ajd ajd is offline
external usenet poster
 
Posts: 16
Default Max of a Single-Cell Array

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?