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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup inquiry again
=VLOOKUP(A2, Sheet1!A:B,2,False)
-- __________________________________ HTH Bob "Lorderon" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup inquiry again
Hi,
Thanks for the reply, but unfortunately this does not work. I put your formula under Col C on Sheet 2 and it will just return the value found on Col B on Sheet 1 which is wrong. Again, on Sheet 2 Col C, I need to put a formula to search the value that matches Col A and Col B on Sheet 2 to that on Sheet 1 then get the value of Col C on Sheet 1 that matches A & B. As you can see from my example below, On Sheet 2, Col A (Dog) and Col B (4) combination has a match on Sheet 1 and that line on Sheet 1 has a Col C value of "Ddata". So the "Ddata" value of Col C on sheet 1 will be copied to Col C on Sheet 2, that is why there is "Ddata" on the Col C of Sheet 2. Wheew! Difficult to explain..... So any other idea?? Thanks! "Bob Phillips" wrote: =VLOOKUP(A2, Sheet1!A:B,2,False) -- __________________________________ HTH Bob "Lorderon" wrote in message ... 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! |
Reply |
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) |