Can you nest Lookup fucntions in an IF function?

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

To clarify G3 says which test they did; F3 says what percentage they got.

Try it like
=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")))

you can use ifs in 365 which makes it a bit shorter as well as you do not need to nest them

But could easily slow things down.
The IFS function will calculate every lookup/vlookup, whereas the nested if will only calculate one of them.

Interesting to know Fluff, every day is a schoolday!

Originally Posted by Fluff13

Try it like
=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")))

Thank you! That worked perfectly (and, most importantly, didn't screw up when I uploaded to Google Drive and thus turned it into a Google Sheet).

Many thanks to you and the other contributors to this thread.

Glad to help & thanks for the feedback.