Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a Text Cell to Reference a Worksheet Name | Excel Worksheet Functions | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
How to reference cell in other worksheet | Excel Worksheet Functions | |||
Can you reference a cell that is sorted in excel 2002? | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions |