Help with INDEX,MATCH,VLOOKUP???

I am a mere mortal and not a developer. I am having a real hard time trying to create a specific set of formulas. I want to match the value of cell to another list in the same workbook and return a value associated with that lookup on the same row of data. I am close but it does not work properly. I am using: =INDEX(Data!A2:A4,MATCH(Pricer!B2,Pricer!B2:B4,0),1) ...where Data!A2:A4 is the info I want to pull from... and Pricer!B2 is the value that matches Note: Pricer!B2 is a "list" function from the Data! worksheet. So when I select a value from the drop-down list on Pricer! worksheet I want to display in the cell next it the cooresponding value on the same row from Data! worksheet. It kinda works...it will display values from Data! worksheet but it mixes up the matches. I can select a value from the drop down list on Pricer! worksheet cell B2 for example and it doesnt change the value in cell C2 where I want it... but it will change the values in cells C3 and C4 - where I dont want it!!! MS Excel help examples is no help at all. I am desperate. Please advise - email is great and I have sent an example workbook. Thanks bobby.reynolds@hughes.net

Try the attached. I have reversed the order to two columns on the second sheet so that VLOOKUP can be used.