Index - Match formula not giving me an expected result
Hello, could some please be kind enough to assist me with the following Excel 2003 (Windows XP) Index - Match query?
In Cell B16 (Sheet1) is the following formula:
Please Login or Register to view this content.
I was expecting the result to be: #N/A
Please refer to my attached spreadsheet.
Is there something wrong in my formula?
Kind regards,
Chris
You are looking for 1022 in column A
It exists in column A so why are you expecting N/A?
Then you are after the 11th Item in the range D2:D16 which is D12 which is 16.
Last edited by mehmetcik; 11-25-2015 at 07:23 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
your formula should change from... =INDEX(Sheet2!$D$2:$D$12,MATCH(Sheet1!A16,$A$2:$A$12,0)) to =INDEX(Sheet2!$D$2:$D$12,MATCH(Sheet1!A16,Sheet2!$A$2:$A$12,0))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thanks Sambo Kid - your suggested formula works well - very much appreciated
Thanks Mehmetcik - my spreadsheet references in my formula were mixed up. All fixed now
You're welcome, glad I could help.
And thx for the rep points!
Last edited by Sam Capricci; 11-25-2015 at 07:36 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks