I hate merged cells
Remove merged cells and fill the same data to the cells.
Then in A3 cell of Comp Sheet
Formula:
=VLOOKUP($B$3,DATA!$A$4:$F$13,3+ROW(A1),1)
Drag the formula down to A4.
I hate merged cells
Remove merged cells and fill the same data to the cells.
Then in A3 cell of Comp Sheet
Formula:
=VLOOKUP($B$3,DATA!$A$4:$F$13,3+ROW(A1),1)
Drag the formula down to A4.
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