C
cynder77
I am tired of filling in data that already exists in my spreadsheet ove
and over . I have a column 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 E = Models, COLUMN G = Cost per peice.
If cell E1 = E4 then cell G1 = G4
Cell range starts on row 3 after my column headings and runs down t
anywhere from row 250 to 700 depending on how bad the month was. Th
Cost (Column G) is formatted as currency if that makes a difference.
The Cost is also referenced in another column, also formatted a
currency, to calculate total cost of the discrepancy.
Any help any of you could provide would be much appreciated.
Thanks
-Dave Corve
and over . I have a column 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 E = Models, COLUMN G = Cost per peice.
If cell E1 = E4 then cell G1 = G4
Cell range starts on row 3 after my column headings and runs down t
anywhere from row 250 to 700 depending on how bad the month was. Th
Cost (Column G) is formatted as currency if that makes a difference.
The Cost is also referenced in another column, also formatted a
currency, to calculate total cost of the discrepancy.
Any help any of you could provide would be much appreciated.
Thanks
-Dave Corve