In C3 Cell of Index Sheet
=IFERROR(HYPERLINK("#'DATABASE'!A"&MATCH(B3,DATABASE!A:A,0),VLOOKUP(B3,DATABASE!A:D,4,0)),"")
Drag it down....
In C3 Cell of Index Sheet
=IFERROR(HYPERLINK("#'DATABASE'!A"&MATCH(B3,DATABASE!A:A,0),VLOOKUP(B3,DATABASE!A:D,4,0)),"")
Drag it down....
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks