=if(isna(vlookup_1),if(isna(vlookup_2), if(isna(vlookup_3),"not present",
vlookup_3),vlookup_2),vlookup_1)


just trying to understand what someone gave me earlier.

if value is #n/a do first lookup
T ^ F
(do second lookup) (if its false do nothing)
T ^ F
(3rd lookup) (do nothing)
T ^ F
(not present) (do nothing)

the last 3 after the comma is what is confusing after the "not present"

vlookup_3), vlookup_2), vlookup_1)) this is the nested part but where does
it go in my diagram?

thanks,