warren7504
New Member
- Joined
- Mar 10, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I am trying to add to the lookup value so that the formula either returns information for a "P" or a "W" but am having trouble adding in the W search. What would be the best way to perform this? Any help is greatly appreciated.
Here is my current formula:
=IFERROR(1/(1/XLOOKUP("P",L9:AEH9,L$7:AEH$7,"")),"")
The formula works as planned and I thought I'd be able to add to it but haven't been able to get it to work as intended yet with the W callout.
Here is my current formula:
=IFERROR(1/(1/XLOOKUP("P",L9:AEH9,L$7:AEH$7,"")),"")
The formula works as planned and I thought I'd be able to add to it but haven't been able to get it to work as intended yet with the W callout.