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