Hi, total newbie here and thus I apologies if there are other threads addressing this (I did look through the first 3 pages and couldn't find one).

I was wondering if you can nest Lookup functions in an IF function?

I'm trying to create a marksheet for the school where I work, whereby the spreadsheet will check which test a student has done (3 options), then look up what mark they have got from 3 different lookup tables.

I tried writing:

=IF(G3=3, "LOOKUP(F3,'Look Up Tables'!A$2:B$102)", IF(G3=2, "LOOKUP(F3,'Look Up Tables'!C$2:D$102)", IF(G3=1, "LOOKUP(F3,'Look Up Tables'!E$2:F$102)", "Absent")))

Can anyone give me some guidance as to whether what I'm attempting is possible and, if so, where I might be going wrong?

Many thanks in advance

TB