Macro to apply IF formula to next set of columns if condition is false

[Ale84]

Dear Forum,

I am currently using an IF formula to retrieve sample names from a dataset (columns AI & AJ in the example workbook). I need to apply the same formula (or at least concept) to a dataset that has at least 100 times more columns. Writing an IF formula for the bigger dataset is near impossible. I will enormously appreciate if you can let me know of ways I can have a macro that basically accomplishes what the IF formula is doing but that doesn't require me to input all the values in the formula manually.

The macro will basically have to ask in column AI if the value in column AG4 is equal to the value on L4, if true then retrieve sample name from column B4. If AG4 is different from L4, then look for value on next column M4 and retrieve value of next column C4 if true, etc. For column AJ, ask if AH4 is equal to V4, if true then retrieve B4, if AH4 is different from V4, then look for value on next column W4 and retrieve value of next column C4 if true, etc.

Thanks a lot,
Ale

[LeoTaxi]

See shorter formule with index and match


Kind regards
Leo

[Ale84]

Thanks a ton Leo, it works perfectly and accomplishes what I wanted!

Cheers,
Ale