Nested IF statement HELP

  • Thread starter Thread starter Rakujan
  • Start date Start date
R

Rakujan

I need to know if its possible to get a VLOOKUP table to work within a
IF statement...

=IF(AA9="Yes","=VLOOKUP(AB6,examtable,2)","=VLOOKUP(AB6,examtable2,2)")

This is what I got, bascially it is to show what grade someone woul
get if they sat either the higher or lower tier paper (both hav
different grade boundaries, that why i need something like this)

I can get it to work to some extend.... only problem is it show th
forumla for the Vlookup in the cell, and doesnt calculate it....

PLEASE HELP

thanks :
 
One thing I see right away is that your VLOOKUP formulas shouldn't have
quotes anywhere near them, and do not need the equals sign there either. The
equals sign is to start the first formula in the cell only.

so try
=IF(AA9="Yes",VLOOKUP(AB6,examtable,2),VLOOKUP(AB6,examtable2,2))
 
Sadly that didnt work it just came up with #N/A
any more ideas/
Click to expand...

Yes -- look at HELP for VLOOKUP:


If lookup_value is smaller than the smallest value in the first column of
table_array, VLOOKUP returns the #N/A error value.


--ron
 
Back
Top