mulitple IFs

[k_babb]

i have a spreadsheet that does a vlookup if cell A7 has text in it which i want to display as a hyperlink
the formula below works great but i dont want it to display anything if the vlookup does not contain any text so i have been trying to insert another IF in the vlookup but cant get it to work

=IF(A7>0,(HYPERLINK(VLOOKUP(A7,Data!A:C,2,FALSE),"File Link")),"")

any help would be great

 

[T. Valko]

i have a spreadsheet that does a vlookup if cell A7 has text in it which i want to display as a hyperlink
the formula below works great but i dont want it to display anything if the vlookup does not contain any text so i have been trying to insert another IF in the vlookup but cant get it to work

=IF(A7>0,(HYPERLINK(VLOOKUP(A7,Data!A:C,2,FALSE),"File Link")),"")

any help would be great

Maybe this...

=IF(A7>0,IF(VLOOKUP(A7,Data!A:C,2,0)<>"",HYPERLINK(VLOOKUP(A7,Data!A:C,2,0),"File Link"),""),"")

 

[Ron Coderre]

If you have Excel 2007 or later, try this regular formula:

=IFERROR(HYPERLINK(VLOOKUP(A7,Data!A:C,2,FALSE),"File Link"),"")

Otherwise, try this one:

=IF(ISNUMBER(MATCH(A7,Data!A:A,0)),HYPERLINK(VLOOKUP(A7,Data!A:C,2,FALSE),"File Link"),"")

Does that help?

 

[Vidar]

deleted post

 

[k_babb]

thanks for that still trying to get my head around the bigger formulas but now i have put it in the spreadsheet it makes more sense
thanks T.valko

 

[T. Valko]

thanks for that still trying to get my head around the bigger formulas but now i have put it in the spreadsheet it makes more sense
thanks T.valko

You're welcome. Thanks for the feedback!