Return Fields Based on Form Entry

I have a list with the following columns:

Vendor    Type       Role         Location         Price Year 1         Price Year 2      Price Year 3

I need to have a form which I can input a price and it will search years 1,2 and 3 and return any matches with all the rest of the record.

So for instance on the form I would have a place to input a rate. If the rate was in a record in year 2 I would pull the other field values into the form.

Rate: $100.00

Vendor      Type               Role      Location         Year 1      Year 2         Year 3

IBM            Onshore         PM      New York                          $100.00

Samsung   Offshore         AVP      New Deli                           $100.00

I have been trying to do this with a list lookup but feel there may be a better way to do this.