I am tired of filling in data that already exists in my spreadsheet ove
and over . I have a list of model numbers that tend to repea
fairly often since i am tracking shipping discrepancies. I am als
tracking the cost per peice of each model. I would like the cost t
automatically fill in if the model exists higher in the table.

EG

COLUMN A = Models, COLUMN C = Cost per peice.

If cell A1 = A4 then cell C1 = C4

Any help any of you could provide would be much appreciated

--
cynder7
-----------------------------------------------------------------------
cynder77's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=26991

in C2 put in the formula
=if(A2="","",vlookup(A2,$A$1:C1,3,False))

then drag fill this down the column.

When you enter a model in column A and this shows an error, you can enter
the price manually. Otherwise, the previous price will be shown.

--
Regards,
Tom Ogilvy



"cynder77" wrote in message
...

I am tired of filling in data that already exists in my spreadsheet over
and over . I have a list of model numbers that tend to repeat
fairly often since i am tracking shipping discrepancies. I am also
tracking the cost per peice of each model. I would like the cost to
automatically fill in if the model exists higher in the table.

EG

COLUMN A = Models, COLUMN C = Cost per peice.

If cell A1 = A4 then cell C1 = C4

Any help any of you could provide would be much appreciated.


--
cynder77
------------------------------------------------------------------------
cynder77's Profile:
http://www.excelforum.com/member.php...o&userid=15371
View this thread: http://www.excelforum.com/showthread...hreadid=269915