Find match between two sheets

[Nordicrx8]

Hey all!

For some reason I'm stumped on this one. I'm sure it's something simple, but I've spent way too much time trying to figure it out.

I have two sheets of data, and need to see if there is a match between them. Generally an easy ask, but the data is reversed.

Example: in the first image, the category label can appear multiple times vertically to list out the associated items:

Outdoor and Sports	Swing Sets
Outdoor and Sports	Outdoor Furniture
Outdoor and Sports	Trampolines

But in the second sheet, it lists it horizontally:

Outdoor and Sports

Basketball Hoop

Grills

Pool Materials

I need to match the item to the category and GIS ID, but at a loss on how to index/match this correctly to see if data matches between the two sheets due to the difference in the data layout - any help would be greatly appreciated!

 

[Kerryx]

you could use Power query to convert to table and do your match

 

[Kerryx]

import table /range into query, select columns and then click on UnPivot Columns

Load back to your sheet

 

[Nordicrx8]

oh boy. I've never used that feature before. I'll try to poke around and see if I can get it working. thanks for the idea!

 

[Nordicrx8]

import table /range into query, select columns and then click on UnPivot Columns
View attachment 70847

View attachment 70848
Load back to your sheet

wow, this was super easy - thank you SO MUCH! I appreciate you!

 

[Kerryx]

no problem glad to help