Hello everyone,
I am trying to solve a problem that requires a index match formula to select from multiple conditions vertical and horizontal.
Doing my head in a bit.
I have attached a sample of what I am trying to do.
The actual sheet has a lot more data on multiple sheets.
I need a kickstart in the right direction, because I am just turning in circiles.
Hoping to hear from you soon
Last edited by capefigaro; 05-04-2016 at 05:24 AM.
with another structure of your data and a helpcolumn.
after that with index / match / match.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Fill in all the cells in the table and can then use this formula.Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks