Quote Originally Posted by DODGE View Post
Thanks JB
I will give this a go and let you know.
Cheers Dodge
Hi JB
Just a dum question.
Why in the formula do you say try this in B2 after I select A2
Why wouldn't I be using B1 and A1?
I want all my codes on sheet 2 to be in column A and all my prices to be next to them in column B.
When I click my drop down list in column A1 on sheet 1
I want the respective prices to be displayed in column B next to them.
EG: Sheet 1 A1 will have a drop down list of codes
As will A2 A3 A4 A5 and so on. Prices will be displayed next to them in B2 B3 B4 etc.
I hope I have explained it ok, I'm new to excel.
Thanks for your help.
Dodge.