Forum Discussion
Solved
Help with VLookup
I'm trying to figure out how to write a proper VLOOKUP function that allows me to pull the proper multiplier from the table below based upon the user's dropdown selections for "Year" and "Asset Type"...
=INDEX($B$2:$G$12,MATCH($B$15,$A$2:$A$12,0),MATCH($B$16,$B$1:$G$1,0))You can try INDEX and MATCH. There are dropdowns in cell B15 and B16 in the attached file.
=INDEX($B$2:$G$12,MATCH($B$15,$A$2:$A$12,0),MATCH($B$16,$B$1:$G$1,0))You can try INDEX and MATCH. There are dropdowns in cell B15 and B16 in the attached file.
This works perfectly. Thank you for your help with this ! OliverScheurich