vlookup function

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have created a "database" type page in excel for users
to input data and select options. One option asks the
user to enter a type of equipment and the payment plan.
Both of these are drop down boxes. I want to return a
value to the cell to display the cost. Normally I would do
a Vlookup function, but is their an function that allows
you to look up two value instead of just one?

any help is greatly appreciated!!
 
Jason-

You could use:

=INDEX(cost,MATCH(A1&B1,equip&plan,0))

array-entered, meaning press ctrl/shift/enter, where

cost = your range of costs
equip = your range of equipment types
plan = your range of payment plans
A1 = user's choice for equipment
B1 = user's choice for payment plan

Of course you could always merge the equipment and plan
ranges in another column (say col. F), and with cost in
col. G, use:

=VLOOKUP(A1&B1,F:G,2,0)

HTH
Jason
Atlanta, GA
 
Back
Top