Return Value From One Column OR Another

[spochedly]

Hello,
I have to return a warehouse location from one column or the one next to it. Think in terms of "virtual" warehouses (the locations in the system):
You might have 2 virtual warehouses...A&B for the sake of simplicity.
Warehouse A might house product A, OR, it might be in Warehouse B....

Product SKU is on sheet 1, and also on sheet 2; page 2 also contains the warehouse locations for all these SKUs between 2 different warehouses (1 column for each warehouse). I need to return the location if the SKU is in either of those 2 warehouses (not necessarily both, but that that would be a cherry on top...).

Can someone please lend some advice on a formula / function to do this?

Thank you in advance!

Steve

 

[sunnyland]

Want to try the following?

What I did is on one sheet I have a column with sku # [column 1]. The formula will look for the corresponding number on another sheet where I have column1 as store1 and column2 as store 2 with the list of skus in store [in column1 there is: 5,25,698,etc...]. I used named range to facilitate understanding.

Not sure I understood everything perfectly the details.

Sometimes it is good to upload a sample so we know exactly how to find a solution. I works with my data layout.

*I start with errors so it doesn't stop the formula.

=IFS(
AND(ISERROR(MATCH(A2,StoreA,0)),ISERROR(MATCH(A2,StoreB,0))),"Not in Store A or B",
AND(ISERROR(MATCH(A2,StoreA,0))=FALSE,ISERROR(MATCH(A2,StoreB,0))=FALSE),"In Store A and B",
AND(ISERROR(MATCH(A2,StoreA,0)),ISERROR(MATCH(A2,StoreB,0))=FALSE),"In Store B",
AND( ISERROR(MATCH(A2,StoreA,0))=FALSE,ISERROR(MATCH(A2,StoreB,0))),"In Store A"
)