View Single Post
  #30  
Old 08-18-2005, 06:30 PM
davelin davelin is offline
Senior Member
 
Join Date: Aug 2004
Posts: 708
Default Re: Tough Excel Question

[ QUOTE ]
[ 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.

[/ QUOTE ]

Good to know.
Reply With Quote