[Year 12 IPM] Practice SAC question

[Mike Brookes]

Hi All
If you add a ,FALSE to the second VLOOKUP function you don't need to 
have the first column in alphabetical order

=VLOOKUP(B12,salary,VLOOKUP(C12,DEGREES,2,FALSE))

Mike Brookes
Chief cook and bottle washer Copperfield College

Mark Kelly wrote:
> A solution is attached...
> 
> The 2-dimensional lookup is achieved with a second lookup in a second 
> lookup table.
> 
> A bit tricky, but a valuable technique.  Note: the BA,MD, PHd etc table 
> must be in ascending alphabetical order for it to vlookup correctly.
> 
> HTH
> 
> Mark K