VLOOKUP HELP

M

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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
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)
 
Upvote 0
Look into the AND function. Something like this

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

HTH
 
Upvote 0
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.
 
Upvote 0
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)
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Using IFNA with 2 Nested VLOOKUPs
Replies
5
Views
274
SanjayGMusafir
SanjayGMusafir
H
  • Question
VLOOKUP Issue with Approximate Match - Need Help Categorizing Customers
Replies
9
Views
501
Peter_SSs
Peter_SSs
M
  • Solved
Conditional HYPERLINKS to worksheet tab based on a cell value
Replies
6
Views
350
smozgur
smozgur
O
  • Question
Vlookup() and Index(Match()) returning N/A, even though the lookup value exists in the range and is identical to that value within the range.
Replies
6
Views
1K
nemmi69
nemmi69
S
  • Question
Advanced Filtering for Non-Exact Matches
Replies
1
Views
379
Anonymous1378
A

Forum statistics

Threads
1,214,651
Messages
6,120,744
Members
448,989
Latest member
mariah3

Share this page

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
Back
Top