INDEX + MATCH: Please help!!
I am trying to create a form that will calculate the price of travel based on the resort and travel dates, in reference to the price list for several resorts broken down by travel dates for price.
I believe I have the correct formula but it keeps coming back as "N/A"
In the travel dates the date in the header is the last date of travel for the corresponding price below. What am I doing wrong?
=INDEX(G3:J10,MATCH(B2,F3:F10,0),MATCH(B3,G2:J2,1))
Last edited by sabmitchell; 08-29-2017 at 09:52 PM.
Are you sure the data in G2:J2 are real dates? test with =isnumber(G2) etc..FALSE intcates text and we will need to conver them.
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
the check in date is smaller (before) than the list of dates shown
so it doesnt know what to do do with the match
put 0 (or lowest date you can possibly enter) into F2 and change the formula to
Formula:
Please Login or Register to view this content.
now you will have an issue if you put a date for checking which is larger than the last date you have in your table so have a think on what you want to do when that happens
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This worked!!! Thank you so much!!
Originally Posted by humdingaling
the check in date is smaller (before) than the list of dates shown
so it doesnt know what to do do with the match
put 0 (or lowest date you can possibly enter) into F2 and change the formula to
Formula:Please Login or Register to view this content.
now you will have an issue if you put a date for checking which is larger than the last date you have in your table so have a think on what you want to do when that happens
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks