VLOOKUP HELP

midstatesguru

New Member
Joined
Oct 5, 2006
Messages
3
<html>I run a self made weekly payroll program in excel. I have a page for each day, and special pay categories for a block of employees.



My question is, how can I use vlookup (or similar function/nested functions) that could reference one column, then take the results of that and check against a second column. ie:



___A___B____C

1___1___1___25

2___1___2___30

3___1___3___21

4___2___1___23

5___2___2___24

6___2___3___29



I need to check in column A for all of the 2's, then take those answers and look in column B for 3 and the answer would result in 29.
Please Help Me!!!!
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Welcome to the board!

If there is only one match:

=LOOKUP(2,1/((A2:A10=2)*(B2:B10=3)),C2:C10)


(if there are more than one, only last match will be returned)
 

Egress1

Active Member
Joined
Mar 2, 2003
Messages
420
Look into the AND function. Something like this

=IF(AND(A1=2,B1=3),C1, "")

HTH
 

midstatesguru

New Member
Joined
Oct 5, 2006
Messages
3
There would only be one correct combination. What the program does is references another file, that is another spreadsheet using starting and ending points (predetermined) that run alphabetically in each column, ie

aaa bbb
aaa ccc
aaa ddd

bbb aaa
bbb ccc
bbb ddd

ccc aaa
ccc bbb
ccc ddd

There would be a group of aaa's, then only one possible option from those answers. All aaa's are listed in one group on the first column, and do not reappear again in the first column. There are no duplicates either.
 

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638

ADVERTISEMENT

Did you try the formula I posted?

( you need double quotes around any text in the formula, you could also change the numbers to references to cells holding your lookup values)
 

midstatesguru

New Member
Joined
Oct 5, 2006
Messages
3
I did not know about the double quotes, but how do I get it to keep a list of the first argument, and then select from those listed to match in the second???? Sorry to be so difficult
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,542
Members
410,549
Latest member
Anaarchie
Top