Excel IF statement with nested vlookup and hyperlink functions help

Magoo360 · Sep 27, 2010

I need some help in getting the below formula to work. Right now excel returns the error as that there is an error in the formula but offers no suggestions. Any help would be appreciated. Thanks.

=IF(VLOOKUP($A8,BidData!$A:$BM,22,FALSE))="","No File",(HYPERLINK(VLOOKUP($A8,BidData!$A:$BM,22,FALSE),"File")))

repairman615 · Sep 28, 2010

I think it was the parens.

Try:

Code:

=IF(VLOOKUP($A8,BidData!$A:$BM,22,FALSE)="","No File",HYPERLINK(VLOOKUP($A8,BidData!$A:$BM,22,FALSE),"File"))

Magoo360 · Sep 29, 2010

Thanks, I had been beating my head against the wall. Thanks again that did the trick.

Excel IF statement with nested vlookup and hyperlink functions help

Magoo360

New Member

Excel Facts

repairman615

Well-known Member

Magoo360

New Member

Similar threads

Forum statistics

Share this page

Excel IF statement with nested vlookup and hyperlink functions help

Magoo360

New Member

Excel Facts

repairman615

Well-known Member

Magoo360

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock