help with index match iferror if

[Nour AlDeen AlKhalil]

Dears
attached is an excel sheet in which Vlookup is not working properly. so I hope you kindly help me with the Index-match nested with Iferror and If to resemble the formula I am using without error in the file.
I am using: =iferror(if(vlookup(......),"Seen","Not Seen") and =iferror(if(vlookup(......),"Listed","Not Listed")
but; things are not exact with vlookup that i have duplication and two interactive sheets

I do really need your help and anticipate many appreciated solutions to my dilemma.

Many Thanks....

Mod Edit: Thread moved to appropriate section.

 

[NARAYANK991]

Hi ,

1. First , delete all the unwanted Conditional Formatting rules ; there are almost 50 of them , and I think if you explain what you want done , these 50 can be replaced by 5.

2. Explain what you want done in the formula part by giving precise worksheet tab references , cell references.

I am not clear on which formula where is to be looked at.

3. Explain what is to be done by the formula , which it is not doing at present.

Narayan

 

[narunfca]

Hi

You have used relative reference instead of absolute reference.

Enclosed the file with solution using both Vlookup and Match functions

with best regards

Arun N

 

[Nour AlDeen AlKhalil]

Thank You for the nice replies;
In Other Words: I want to use (Index-Match) instead of Vlookup
current: (=IFERROR(IF(A2=VLOOKUP(A2;'clinic StatsDr. Name'!$A$2:$K$350;1;FALSE);"Seen");"Not Seen")
also; is (index-Match) better than VLookup in returning the exact values I want in case my file has many duplicated values in both tables I am interacting...

 

[narunfca]

Thank You for the nice replies;
In Other Words: I want to use (Index-Match) instead of Vlookup
current: (=IFERROR(IF(A2=VLOOKUP(A2;'clinic StatsDr. Name'!$A$2:$K$350;1;FALSE);"Seen");"Not Seen")
also; is (index-Match) better than VLookup in returning the exact values I want in case my file has many duplicated values in both tables I am interacting...

Hi,

In my example file, I have mentioned Vlookup option, I have mentioned the Match option also in next column.

No need to use Index in your case.

Further I just want to clarify that both Vlookup and Index Match will return the same values. No difference at all.

with best regards
Arun N

 

[Nour AlDeen AlKhalil]

Thank You Arun, you are of a great help. I think the weakness of Vlookup is the duplication in values and the discrepancy between the two sheets. is it not?
Thank You