Cross-reference cells across sheets

[reddevilanalyst]

I have a column for products in A1 and their cost in C1 in Sheet 1 and they are randomly distributed. Now I need to copy all the costs for the subsequent products into sheet 2 in E1 cell.

 

[Fluff]

Duplicate to: Helping with a formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.