needhelp creating pricing sheet

Hi Sky,

Note:
See fractory codes list in collum A
I would like to enter codes in collum H
Whe I do that, the code will automactically go into columm H and the decription in collum B will go into Collum I
and the prices in collum C will go into collum J
How can i do this?
I want to be able to continue entering codes down collum G and in no particuliar order.

This is confusing to me - can you reword your request??

ColA ColB Col C Under A would be a number code Under b would be description "Tires" Under C price
649 Tires $100.00
650 Nuts $2.50
651 washer $1.00

So I got a table or list as above

In another part of the worksheet let's say N15, My curosr is in N15 I would put 649. 649 would go into N15 and automactically tires would go into O15 and the price would go into P15
Then on N16 I input 650 and the same thing happens but the nuts would show up on O16 and so on.

I hope this helps.

Did you look at the spread sheet I uploaded. First time to this board.

Yeah, I looked at the spreadsheet - that's where I got your quote

I think this is what you are looking for...............

You can come back always.
We will help or maybe somebody else.