I am trying to do a Double nested vlookup where vlookup 1 looks for DOB in range and and vllokup 2 looks for surname in range, only when both vlookups match will it return the corresponding column value
=IF(VLOOKUP(Sheet1!A1,Sheet3!$A:$G,(VLOOKUP(Sheet1!F1,Sheet3!$F:$F,1,FALSE)),FALSE),"NULL")...