Forum Discussion
Index Match Return with IF function.
Use "", not " " (the latter is a string consisting of a space).
HansVogelaar, I Already tried that before, I just put a space to make it visible 🙂
Could you attach a small sample workbook demonstrating the problem?
HansVogelaar I'm wondering if the "IF" function is not compatible with the INDEX and MATCH function.
I even tried to test the formula as:
=IF(INDEX(DATABASE.!$I$2:$I$1200,MATCH(1,($B$1=DATABASE.!$A$2:$A$1200)*(C17=DATABASE.!D2:D1200),0))="","not found","found"
Instead of giving me "not found", it gives me "#N/A".
This is the breakdown of my formula
DATABASE.!$I$2:$I$1200 - Rank of the crew w/c the formula will look into.
$B$1 - Manager who is In-charge of the crew.
C17=DATABASE.!D2:D1200 - Date of the Registration
My Goal: To Show the Rank of the Crew if I have selected a manager w/c the crew is registered to, in respect to the registered date.
I hope you or somebody can help me 🙂
Hope the attachment will help.
Sheet, string connected toSheet w/c I want the result to be shown
Are you sure MATCH() works within the formula? If any part of the formula returns an error, entire formula return error as well. If MATCH() returns #N/A you have that as result. To handle errors you may use IFNA(), ISNA() or, more general, IFERROR() and ISERROR(),
