=IFERROR(INDEX('Customer records'!$A$3:$D$499,'Customer records'!$G3,4),"")
Above is the formula I am using to transfer information from one page to another. I am building a customer database that has hyperlinks to files containing paperwork on jobs and information for the machines we have worked on along with pictures. I have a main page with a customer selection list and then a table populates with all of the customer's info and machines. On a separate sheet I have a table with all of the customers, it would be inconvenient to have to scroll through this list to find that one job I'm looking for so I need to transfer all the info for one specific customer to one page, I have accomplished that but the hyperlinks do not transfer. Could I get some advice on what I need to add to get the links to transfer? I can't provide screenshots or the file itself
Bookmarks