Gurus,
I am having an issue using Match. I am using it in combination with Index however, the result is N/A. Please review the Picture supplied.
the ultimate goal is to have the result as Mon 7/11/16.
Attachment 471464HTML Code:
TIA,
Tim
Gurus,
I am having an issue using Match. I am using it in combination with Index however, the result is N/A. Please review the Picture supplied.
the ultimate goal is to have the result as Mon 7/11/16.
Attachment 471464HTML Code:
TIA,
Tim
It would be easier for someone to help if you would upload the file instead of a picture of the file. To attach a workbook click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window. I would also add that the logical condition of the IF function is different in the picture than in post #1.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Here is the file along with a picture,
Tim
This is not working because B is text and F is numeric. While it woud be a simple matter to convert the numeric to text MATCH(TEXT(F16,"0.0"),B:B,0)
I would 1st question what you are trying to do with that formula in B?
Formula:Please Login or Register to view this content.
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
hmm looking at what you have in B, I think this will do the same thing...
1. start with a "seed" of 1 in B9
2. use this in B10 and copy down...
=IF(A10="","",IF(A10<>1,B9+0.1,INT(B9)+1))
Ford,
I am using the data in column (F) to determine the tasks predecessor. When that is matched, then I find that tasks end date. The result will be the next date. Thewill determine that date based on weekends and holidays.HTML Code:
Thanks,
Tim
Yes, I get that part. You cannot search for text in a numeric range or vise versa, thats why I said you need to either convert the search criteria to text (i showed how above), OR change the criteria range to numeric (which I did with my shorter formula)
Ford,
Okay. Back on this spreadsheet now. I followed your short formula and it appears to work. However, I get random MATCH errors. Please have a look.Match error.jpg
Try this slight modification of Ford's formula in B10 and down which forces Excel to round to only one decimal place so that errors are not caused when the 30th or so decimal place is different:Let me know if you have any questions.Formula:Please Login or Register to view this content.
JeteMC,
Thanks for your input. With Ford's and your help the formula works great!!
Thanks Again,
Tim
You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks