INDIRECT Hyperlink


Currently working on a spreadsheet that collects data from a few other sheets using INDIRECT/CONCATENATE and I’m trying to use a Hyperlink to open the needed spreadsheets to connect but when I do it doesn’t fill in the cells but I open them manually it does. Is there a way to change my formula into a MATCH or something to fix this? 

=IFERROR(INDIRECT(“‘V:DAILY FIGURESPricing”&$B$5&””&$C$8&””&$D9&””&F$4&”‘!$E$333”),CONCATENATE(“Please open workbook.”)) 

Is the Formula, 

By: Ben Miller

Leave a Reply

Your email address will not be published. Required fields are marked *