agwalsh
asked on
Vlookup with matching column NAME not number?
hi
Is there any way to reference a column name instead of a column number in a vlookup? in the attached file, I'd like to be able to reference the Premium column in the formula rather than column 2. Any suggestions?
Thanks!
Anne
vlookup-EE-example.xlsx
Is there any way to reference a column name instead of a column number in a vlookup? in the attached file, I'd like to be able to reference the Premium column in the formula rather than column 2. Any suggestions?
Thanks!
Anne
vlookup-EE-example.xlsx
ASKER
Hi
I tried that and got N/A? Am attaching file..vlookup-EE-example-version-02.xlsx
I tried that and got N/A? Am attaching file..vlookup-EE-example-version-02.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for this.. elegant solution.
try this
=VLOOKUP(C11,$A$4:$B$7,MAT
cheers, teylyn