Ethnod
New Member
- Joined
- Jan 17, 2024
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- Mobile
- Web
I need help, I have a formula pulling data from a specific sheet, looking up using acc numbers. It is looking for a specific result, is yes it writes yes and if it gets anything else it writes no. There is an error check there also that if it gets a null 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?
=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?