If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Vlookup - Multiple columns - How do I do this in Excel?
All
I have a spreadsheet like this: Sheet 1 Jan Feb Mar Apr May Jun Col A Col B Col C Col D Col E 0 0 0 0 0 0 0 SVOP SOM013 SB124 SoES - Client Support Technical (284) 0 0 0 0 0 0 0 DKL E3P ZLP Sheet 2 Col A Col B Col C Jan Feb Mar Apr May SB124 DKL 10 11 20 6 7 SB124 E3P 22 17 10 17 27 SB124 ZLP 90 41 50 61 14 SB125 DKL 10 11 20 6 7 SB125 DKL 19 21 10 16 17 SB125 DKL 14 31 70 68 71 I'd like to lookup the value where Sheet1(Col D) = Sheet 2(Col A) and Sheet1(Col A) = Sheet 2(Col B). I'm posting actual hours worked by a group on a project. Thanks in advance Steve --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/03 |
#2
|
|||
|
|||
Vlookup - Multiple columns - How do I do this in Excel?
Steve,
You don't say what value you want to look up, just the value whe Sheet1(Col D) = Sheet 2(Col A) and Sheet1(Col A) = Sheet 2(Col B). Do you want the lookup formula to be on Sheet1 or Sheet2? And which column from which sheet do you want the value of, when the two conditions above are met? HTH, Bernie MS Excel MVP "SteveJ" wrote in message .. . All I have a spreadsheet like this: Sheet 1 Jan Feb Mar Apr May Jun Col A Col B Col C Col D Col E 0 0 0 0 0 0 0 SVOP SOM013 SB124 SoES - Client Support Technical (284) 0 0 0 0 0 0 0 DKL E3P ZLP Sheet 2 Col A Col B Col C Jan Feb Mar Apr May SB124 DKL 10 11 20 6 7 SB124 E3P 22 17 10 17 27 SB124 ZLP 90 41 50 61 14 SB125 DKL 10 11 20 6 7 SB125 DKL 19 21 10 16 17 SB125 DKL 14 31 70 68 71 I'd like to lookup the value where Sheet1(Col D) = Sheet 2(Col A) and Sheet1(Col A) = Sheet 2(Col B). I'm posting actual hours worked by a group on a project. Thanks in advance Steve --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/03 |
Thread Tools | |
Display Modes | |
|
|