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