Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup inquiry again
Hi,
I have 2 worksheets "Sheet1" and "Sheet2" "Sheet1" contains my raw data which is: Col A Col B Col C Dog 1 Adata Cat 2 Bdata Bird 3 Cdata Dog 4 Ddata Cat 5 Edata Bird 6 Fdata Dog 7 Gdata Cat 8 Hdata Bird 9 Idata "Sheet2" contains my work data and I need to fill in Col C on this worksheet: Col A Col B Col C Dog 4 Ddata Cat 5 Edata Bird 6 ??? Dog 1 ??? Cat 8 ??? Bird 3 ??? Dog 7 ??? Cat 8 ??? Bird 6 ??? So, how to get the correct result (that is fill-in the "???" items)? I already fill-in the first 2 items on Col C, meaning it needs to find the data in Sheet1 that matches Col A and Col B on Sheet2, then copy teh reuslt in Col C on Sheet2. How? Pls help. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question - 2nd Inquiry | Excel Discussion (Misc queries) | |||
Pivot Table inquiry | Excel Discussion (Misc queries) | |||
Counting Function Inquiry | Excel Discussion (Misc queries) | |||
a exact string search inquiry | Excel Worksheet Functions | |||
Pivot Table inquiry | Excel Discussion (Misc queries) |