Return value from a column based on a combobox option

I'm sure there must be an easy way to do this!

Ok. I have data that looks something like this:

A B C D
2 Product A1 A2 A3
3 0001 6 1
4 0002 1
5 0003 4 2
6 0004 2 2

I also have a combobox with a list of the codes from row 2, i.e. A1, A2, A3 that are linked to cell U7.

Right, what I need is a formula to drag down in column E that looks to see what the value is in cell U7 (from the combobox) and then check the corresponding column from the table - if there is a value, return the product number.

Therefore, in the above example, if the value in cell U7 was A2 cells E2:E4 would be blank, cell E5 '0003' and cell E6 '0004.'

Unfortunately, I can't upload documents from my work computer. Any help, as always, most appreciated.

SA

Ok. Think I might have sorted this myself with:

=IF(HLOOKUP($U$7,$2:$692,ROWS($2:3),FALSE)>0,B3,"")

SA