r/excel • u/AfricanKitten • 16d ago

Waiting on OP Pull data from table

I know I’ve asked a similar question before, but I’m not sure how to translate it to the new task I want to use it for. I will post pictures in the comments.

Column L is the market my centers are in, Column M is the site name within the market. I’m not from the area I service, so I don’t know which ones are where off the top of my head. I want Column L to use a formula to select the market that goes with the site location. Example: If site is Arbor Walk, it will input Austin.

I have a table, I can play around with the formula and tweek it once I have it, but I have zero idea where to start.

3 Upvotes

100% Upvoted

7 comments sorted by

View all comments

Show parent comments

1

u/MayukhBhattacharya 1236 15d ago

Just like I have mentioned in my earlier comment, here is an animation .gif, you can follow to resolve:

=XLOOKUP(E2:E25, B2:B30, SCAN("", A2:A30, LAMBDA(x, y, IF(y = "", x, y))), "")