Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP won't work
I have 5 columns on two worksheets, same book, idential columns. I want
columns c, d, and e to populate from the 2nd sheet if columns a & b are the same on both. I need the combination of column a to column b to match (items are doubled in column a; last three columns are determined then by b). I tried VLOOKUP (using A2:B2 as the lookup) but that didn't work. I've tried different IF and AND formulas, and just can't seem to get it right. Can someone help please?!?! |
#2
|
|||
|
|||
Try
=INDEX(Sheet2!C2:C20,MATCH(A4&B4,Sheet2!A2:A20&She et2!B2:B20,0)) entered with ctrl + shift & enter where you would return values from C2:C20 where A4&B4 match in A2:B20 Regards, Peo Sjoblom "o1darcie1o" wrote: I have 5 columns on two worksheets, same book, idential columns. I want columns c, d, and e to populate from the 2nd sheet if columns a & b are the same on both. I need the combination of column a to column b to match (items are doubled in column a; last three columns are determined then by b). I tried VLOOKUP (using A2:B2 as the lookup) but that didn't work. I've tried different IF and AND formulas, and just can't seem to get it right. Can someone help please?!?! |
#3
|
|||
|
|||
Hi!
Maybe something like this: =IF(AND($A1=SHEET2!$A1,$B1=SHEET2!$B1),SHEET2!C1," ") Copy across as needed. If this isn't even remotely close to what you want, perhaps you should post some sample data (in great detail) along with the results that you are expecting. Biff -----Original Message----- I have 5 columns on two worksheets, same book, idential columns. I want columns c, d, and e to populate from the 2nd sheet if columns a & b are the same on both. I need the combination of column a to column b to match (items are doubled in column a; last three columns are determined then by b). I tried VLOOKUP (using A2:B2 as the lookup) but that didn't work. I've tried different IF and AND formulas, and just can't seem to get it right. Can someone help please?!?! . |
#4
|
|||
|
|||
The formula used (adapted to my specific sheets) is:
=INDEX('12 All'!C2:C20,MATCH(A2&B2,'12 All'!A2:A20&'12 All'!B2:B20,0)) My 2nd sheet (containing the values to populate from) is 12 All. The 1st sheet (needs to be populated) is 10 All. I clicked on the sheets instead of typing in. This formula returned #VALUE. Both sheets are sorted in ascending order; column A has numbers, B has text, C, D, and E will all be numbers. Any additional help would be appreciated! Thanks, Darcie "Peo Sjoblom" wrote: Try =INDEX(Sheet2!C2:C20,MATCH(A4&B4,Sheet2!A2:A20&She et2!B2:B20,0)) entered with ctrl + shift & enter where you would return values from C2:C20 where A4&B4 match in A2:B20 Regards, Peo Sjoblom "o1darcie1o" wrote: I have 5 columns on two worksheets, same book, idential columns. I want columns c, d, and e to populate from the 2nd sheet if columns a & b are the same on both. I need the combination of column a to column b to match (items are doubled in column a; last three columns are determined then by b). I tried VLOOKUP (using A2:B2 as the lookup) but that didn't work. I've tried different IF and AND formulas, and just can't seem to get it right. Can someone help please?!?! |
#5
|
|||
|
|||
Hi Biff,
That gave me actual answers, which is closer to where I want to be, but still doesn't look right. As detailed as I can: Sheet1 (<--this is the actual name of the sheet - easier for getting help!!) A(Cust) B(Svc) C(Acct) D(Master) E(Ledger) 1006 DJNS 1006 ER 1214 DJNS 1345 PIR Sheet2 - Exact same column mapping, but C, D, & E contain data based on the combination of A & B. 1006 appears in both DJNS & ER, and they will have different account numbers (column C) depending on which it is. I really hope that makes sense!! Essentially, I want Excel to look at column a, then at column b, and based on the combination compared to sheet2, return the value from sheet2, col c. Thanks in advance!! Darcie "Biff" wrote: Hi! Maybe something like this: =IF(AND($A1=SHEET2!$A1,$B1=SHEET2!$B1),SHEET2!C1," ") Copy across as needed. If this isn't even remotely close to what you want, perhaps you should post some sample data (in great detail) along with the results that you are expecting. Biff -----Original Message----- I have 5 columns on two worksheets, same book, idential columns. I want columns c, d, and e to populate from the 2nd sheet if columns a & b are the same on both. I need the combination of column a to column b to match (items are doubled in column a; last three columns are determined then by b). I tried VLOOKUP (using A2:B2 as the lookup) but that didn't work. I've tried different IF and AND formulas, and just can't seem to get it right. Can someone help please?!?! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP not returning results | Excel Worksheet Functions | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
a VLOOKUP quirk | Excel Worksheet Functions | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |