select an option from H2 and cells (J3:J8) will automaticly update with Col A info

[-emma-]

Hi All,
Thanks for looking.
Please see the attached.
The yellow cell (H2) is a validation list.
Idealy i would like to select an option from H2 and the pink cells (J3:J8) will automaticly update with the information held in column A.
Any help would be appriceated.
Thanks in advance.
Emma x

[Dean England]

See if this does what you want. Enter this formula in J3 and copy down to J8.

Please Login or Register  to view this content.

Hope it helps you out.f you need more info on Sumproduct visit the site listed below.



http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Dean

[corinereyes]

Try this formula on J3 copy down:

Please Login or Register  to view this content.