"TYLER BOSSE" wrote:
i need to create a easy way for me to do quote for my company.
i have over ten different % increases that need to be applied
to the quote. i have the table set up and the cells ready but
i need to get the answer to the cells that are going to be
linked to the table. so lets say that: A1-A10 is the part,
B1-B10 are the prices. lets say in H1 i have the part
(the part is a number). in I1 i need the price to be
there. i dont know how to do this. any help???

=VLOOKUP(I1,$A$1:$B$10,2,FALSE)

That looks up I1 in A1:A10 and returns the price from the corresponding cell
in B1:B10.

But you said %increase at first, not price. Not sure if or how that changes
anything.