Can you advised on how to apply the MATCH and INDEX function for the attached excel file.
Can you advised on how to apply the MATCH and INDEX function for the attached excel file.
hi yjohari. you mean to use INDEX & MATCH to substitute your VLOOKUP? try this:
=INDEX($C$3:$E$24,MATCH($H$4,$A$3:$A$24,0),MATCH(G5,$C$2:$E$2,0))
copy down. you should use Sneaker ID instead of Sneaker Name so that it would work perfectly. if i'm wrong, you could let us know what is the desired results you wish to see.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Power Up the VLOOKUP
=VLOOKUP($H$4,$A$3:$E$24,MATCH(G5,$A$2:$E$2,0),0)
Azumi
See the attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks