LinkBack URL
About LinkBacks
Hello,
Attached is a spreadsheet that i am working with. It is a 12-story mall. I want to be able to search a store and tell me which floor it belongs to.
Hello,
Attached is a spreadsheet that i am working with. It is a 12-story mall. I want to be able to search a store and tell me which floor it belongs to.
Re: Index Match-Sumproduct- Lookup-type formula?
Try this.. Array Entered formula..(using ctrl + shift + enter)
Formula:
Please Login or Register to view this content.
Check the attached file..
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Or this.....
In B17
and copy down.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Third alternative;
=INDEX($K$3:$K$14,SUMPRODUCT(($A17=$A$3:$J$14)*ROW($1:$12)))
Btw you have a typo in cell a18 so it will return an error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks