Help needed with complex nested Vlookup, IF statement formula

[Ethnod]

I need help and I am hoping someone here can assist.

I have a formula pulling data from a specific sheet, looking up using acc numbers. It is looking for a specific result, if yes it writes "Yes" and if it gets anything else it writes "No". There is an iferror check there also that if it gets an error result it replaces that with a "No" also.

=IFERROR(IF(VLOOKUP(A2,'**file location on server**\[**file name**]**Sheet name**'!$B$2:$CM$500000,43,0)="**Specific result I am looking for**","Yes","No"),"No")

When I run that formula I get all No's, which is incorrect, yet when I separate the formula out in different cells and then do the nested parts in stages it works fine and I can verify that the data is correct. Same principle but just in stages instead of nested like above.

Any thoughts? I can see nothing wrong with the formula and in principle it should be working

[FlameRetired]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

Since you are new I will post it for you this time
https://www.mrexcel.com/board/thread...rmula.1252055/

[FlameRetired]

Ethnod,

I accidentally issued you an infraction. What I intended was a warning. I've removed the infraction. My apologies.

Dave

[Pete_UK]

You also closed the thread, Dave, so the reply that I was composing was lost when I came to posting it.

Pete

[FlameRetired]

You also closed the thread, Dave, so the reply that I was composing was lost when I came to posting it.

Pete

Yeah. My apologies Pete. I had not realized that I did that until some time late. Fortunately Ali caught that and fixed it.