XLOOKUP of one Value Within 2 Columns

[meppwc]

I cannot figure out how to make XLOOKUP search on a particular value on one worksheet against 2 columns on a different worksheet
EXAMPLE
Worksheet = "Equipment"
Formula will be in cell B2
Look for the value in cell G2 using columns A & B of worksheet "LOOKUP"
If found in either column, return "EXISTS", if not found, return nothing.

 

[Fluff]

How about

=IF(OR(ISNUMBER(XMATCH(G2,lookup!A2:A1000,0)),ISNUMBER(XMATCH(G2,lookup!B2:B100,0))),"Exists","")

 

[Crystalyzer]

Do you want XLOOKUP to return an array or do you just want to know if the value in G2 exists in either A or B on the Lookup sheet?

 

[meppwc]

Fluff.............the formula returned blank when it should have returned "Exists"

 

[Fluff]

If it's returning "" then the value in G2 was not found on the Lookup sheet.
Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[meppwc]

Fluff, disregard last comment. I had to expand the lookup from 1000 to 10,000 and it works correctly. Thanks so much

 

[Fluff]

Glad to help & thanks for the feedback.