Data can be tough AP
New Member
- Joined
- Aug 30, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi all,
I am trying to quickly clean up some data using the IF functions and cannot seem to get where I want. I have a dataset, where I am using a vlookup to find a function if true, and if successful I would like to the TRUE value to return a certain label, and if FALSE another one of course. The problem is I cannot seem to get the formula to return any value except for the value the look up function is finding. Ideally I wanted to use the IFERROR as well to clean up the NAs but not sure if this is also possible in one go.
Is there any advice you can give me? I've attached a mock sheet just in case.
Best regards!
I am trying to quickly clean up some data using the IF functions and cannot seem to get where I want. I have a dataset, where I am using a vlookup to find a function if true, and if successful I would like to the TRUE value to return a certain label, and if FALSE another one of course. The problem is I cannot seem to get the formula to return any value except for the value the look up function is finding. Ideally I wanted to use the IFERROR as well to clean up the NAs but not sure if this is also possible in one go.
Is there any advice you can give me? I've attached a mock sheet just in case.
Best regards!