In B14 cell
Formula:
=IF(ISNA(VLOOKUP($A14,$A$3:$G$9,MATCH(B$13,$A$2:$G$2,0),0)),"",VLOOKUP($A14,$A$3:$G$9,MATCH(B$13,$A$2:$G$2,0),0))
Drag it down and right...
In B14 cell
Formula:
=IF(ISNA(VLOOKUP($A14,$A$3:$G$9,MATCH(B$13,$A$2:$G$2,0),0)),"",VLOOKUP($A14,$A$3:$G$9,MATCH(B$13,$A$2:$G$2,0),0))
Drag it down and right...
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