View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default Reference a cell in another worksheet?

How do I populate a cell using another worksheet as a reference?

For example, if Sheet1 looks like this:

A B C
1 Part Color Price
2 Desk Black 200.00
3 Chair Black 100.00
4 Lamp Gold 50.00

Sheet2 looks like this:

A B C
1 Black Gold
2 Chair 100.00 150.00
3 Lamp 35.00 50.00
4 Desk 200.00 300.00

I want column C in Sheet1 to pull the price depending on the two crietria.

Any ideas?

Thanks.

Kevin