Hi All,

I am trying to get some information contained in a cell on a seperate sheet and put it in another sheet.

Basically the cell with the information is a drop down. When I select a specific text from the list, I want it to be displayed in another cell with a value indicated in another cell.

For example,

A2 = Incidental
B3 = 2
A3 = Incidental
B4 = 4

If a2:a10 = Incidental, then take sum of b3:b10 and put it in sheet x, A1

Hope that helps.

Thank you everybody.

Newb