Hi Expert
Can you assist to check on my index match formula, as I can't match the correct answer from the sample 1 started from row Ken to row King.
Index.png
Hi Expert
Can you assist to check on my index match formula, as I can't match the correct answer from the sample 1 started from row Ken to row King.
Index.png
Last edited by AliGW; 11-19-2020 at 01:47 AM. Reason: Irrelevant section of title removed - this is a help forum!!!
Your vertical lookup range was incorrect - it started at A1 instead of A4. Use this:
=INDEX($B$3:$D$12,MATCH($F4,$A$3:$A$22,0),MATCH(G$3,$B$2:$D$2,0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I'm also having a similar issue. I fixed the formula as you described which corrected the 1st row of data but copying formula down didn't work.
Never mind. I figured out my issue with references. Thanks for your response to rhbnewbie .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks