lookup value and return other cells value help please

Hi,

I'm looking for some help, I've been trying many things for a couple days now (VLOOKUP, INDEX, MATCH) but cant find the right formula for me, or I'm doing something wrong....
I'm have very basic excel knowledge but willing to learn. Can someone guide me in the right direction?

In the tires sheet i have prices from a set of tires (Column A), based on that value I'm trying to add the Cat A & Cat B (Column C & D) from the price sheet ( Column E )
ex. if the price in column A (tires) is 66.70 i want to add in column C & D the corresponding cat from Column A & B (tires).
Anyone can help me in the right direction?

Thanks, J

Book1.xls

I think i found a solution, if anyone has another option or some advice, would be appreciated.

=INDEX(Price!A7:A231,MATCH(Tires!A3,Price!E7:E231,0))

To try to improve on things I used this formula in C7 of the Price sheet:

=ROUND(SUM(C7,D7),2)

(changes in red) to round all the prices to 2 decimal places). Then I used this formula in C2 of the Tires sheet:

=IFERROR(INDEX(Price!A:A,MATCH(ROUND($A2,2),Price!$E:$E,0)),"")

then copied into D2 and then copied both formulae down to row 116 - very little improvement.

Do you want to use an inexact match? If so, would this be nearest (both above and below) or just below?

Hope this helps.

Pete

Thanks, I only need an exact match, any idea what I can do when there are multiple matches?

There needs to be some other criteria to be able to distinguish between the duplicates.

There are 10 totals with a value of 2.94, and although the Cat.B values are all the same, the Cat.A values vary from Cat. 505 to Cat. 514. How would YOU choose the appropriate Cat.A value manually?

Hope this helps.

Pete

Gone have to check with colleagues after the weekend, not sure about that
thanks for your help, learned from it!

Glad to have helped, and thanks for marking the thread as Solved.

As you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete