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!!!!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

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
 

Forum statistics

Threads
1,141,167
Messages
5,704,674
Members
421,360
Latest member
AJPlant

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top