I'm trying to build a quick form to allow a user to calculate certain data using a data table. I am using
VLOOKUP to achieve this.
This is my current formula:
However, Excel is evaluating this to
#VALUE!. Having step through the calculation, this is what it's trying to evaluate:
Obviously my issues lies here:
LOOKUP(2500,"C26:CT26",C37:CT37) specifically where it's trying to parse
"C26:CT26" as a valid table array.
Is there anyway that I can make this work?