Forum Discussion

Choppa1's avatar
Choppa1
Copper Contributor
Jan 08, 2025

Lookup & Reference

Need some help formulating this one...

If I have a site in either the F "or" G column I need the corresponding region identified in the H column. I have the XLOOKUP in the H column but currently it's only applied top the F column. I don't know how to apply it or this kind of lookup and reference to two columns.

The corresponding regions are identified on a separate tab...

Can anyone help me out with this?

Resources