Link to home
Avatar of vegas86
vegas86

asked on

Excel Array Formula Help/Suggestions

Hello,

Based on the attached example, can anyone suggest a simpler formula other than the array formula in cell A4 on sheet 2?

I was hoping for just a simple index match as I have roughly 24,000 cells to copy the formula to and I would prefer to not have an array slowing the sheet down.

Thank you!
examplefile.xls
SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of vegas86
vegas86

ASKER

Thank you both for your help, all three suggestions work!! :)