using sumif formulas for multiple items (I think?)

[elainey]

I have a stock spreadsheet that I want to fill in as I go so when I choose a product from a drop down list in column A, the corresponding (trade and retail prices automatically appear in columns E and F. I tried a sumif formula but I don't really know what I'm doing. All the data is in worksheet 2: stock items are in column A the trade and retail prices are in column B and C. There are 32 items in the list (will gradually add more) and the same number of corresponding prices. Is this a sumif or is something more programmy required?

Thanks, Elaine

[etaf]

you should use a lookup
either vlookup or index/match

assuming the information starts at row 2
in column E2 put

=Vlookup(A2,sheet2!A:C,2,false)

in F2
=Vlookup(A2,sheet2!A:C,3,false)

[elainey]

thanks! I'll give it a try..

[elainey]

Wayne,

Thank you so much. The formula worked right away no problem.

Kind regards,

Elaine

[etaf]

glad it worked for you
thanks for the rep