Re: Tough Excel Question
[ QUOTE ]
[ QUOTE ]
She really wanted the user to have to enter "0.25" in 1 box and "20" in another box then have it return the value but entering 0.25/20 is almost just as good
[/ QUOTE ]
You can easily do this. Make two user-input cells like E1 and F1. Have hidden a third cell like G1 that concatenates these two cells. Do the vlookup on this cell. Voila.
[/ QUOTE ]
You can do the concatenation right in the vlookup.
|