Nested if with vlookup and hyperlinks to folder - Excel

J Musy 0
Viewed 22

I am able to use vlookup to get a folder address from a table and ensure it appears as a hyperlink. However, I am unable to put this into a nested if so that I can look through multiple tables.

The following formula only works for the first if statement.

=IF(VLOOKUP(G11,database!$D$3:$F$1000,2,FALSE) <> 0, HYPERLINK(VLOOKUP(G11,database!$D$3:$F$1000,2,FALSE),""),
IF(VLOOKUP(G11,database!$H$3:$I$1000,2,FALSE) <> 0, HYPERLINK(VLOOKUP(G11,database!$H$3:$I$1000,2,FALSE),"")))
excel
1 Answers

Handle errors better:

=IFERROR(HYPERLINK(VLOOKUP(G5,database!$D$3:$F$1000,2,FALSE),""),HYPERLINK(VLOOKUP(G5,database!$H$3:$I$1000,2,FALSE),""))
J Musy0
Related