Data Lookup in multiple columns -

[A De Luna]

The FS classification column in the mapping system tab has multiple map codes per company (in this case 5 major ones). I would like each map code to match the FS classification on the "all" tab.

My attempts at vlookup, match/offset are not strong enough to make it work.

 

[PCosta87]

Hi,

Assuming I understood correctly, please refer to attachment for solution...
It is not the most elegant but I believe it works as intended.
I'm sure there are other solutions (array formulas, for instance), but testing some I realized they were way too resource intensive and would take a very long time to process for this amount of data.

Other ways could involve some VBA coding but for now see if this one helps

 

[John Jairo V]

Hi to all!

Another option could be:

=IFERROR(INDEX('Mapping System'!R$8:R$511,MAX(INDEX(('Mapping System'!K$8:P$511=B695)*(ROW('Mapping System'!K$8:K$511)-ROW('Mapping System'!K$7)),))),"")

Blessings!

 

[A De Luna]

Hi,

Assuming I understood correctly, please refer to attachment for solution...
It is not the most elegant but I believe it works as intended.
I'm sure there are other solutions (array formulas, for instance), but testing some I realized they were way too resource intensive and would take a very long time to process for this amount of data.

Other ways could involve some VBA coding but for now see if this one helps

Much appreciated. It solved about 50% of my problem.

 

[PCosta87]

Much appreciated. It solved about 50% of my problem.

Don't mention it
You should use @John Jairo V's solution though.