multiple ifs

[T]

I am looking for help with a worksheet I am trying to
create. I want to be able to enter a purchase price for a
home, and then have excel compare that price to a sheet
with a fee schedule based on that purchase price. For
example, on Sheet 1 I would enter a purchase price of
250,000. I want it to got to Sheet 2 where there is
basically a database of purchase prices, from 100,000 to
500,000 with the corresponding fee, and enter the correct
fee back in a cell on Sheet 1. Anyone know how?
Thanks!

 

[Biff]

Hi!

Use a vlookup function for this.

Say you enter the purchase price in sheet1 A1 and you want
to have the info that corresponds to that purchase price
displayed in sheet1 B1.

The table of purchase prices and fees is on sheet2. Col A
is the purchase price and col B is the fee. The total
range of the table is sheet2 A2:B100

In sheet1 B1 enter this formula:

=VLOOKUP(A1,SHEET2!A2:B100,2,0)

To make things a little easier, you could use a dropdown
list of the purchase prices and just point and click! I'm
a big fan of point and click!

Biff