Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3-4 conditions in a vlook-up
I have an excel file, hich have Coloum like following: A - Business Unit; B - Doc Type; C - Amount
I have another file which have the data for the approvers of the respective business unit & respective Doc type, and for amount pertaining to a range. For example for a particular business unit & documne type, there can be multiple approver, 1 can approve entries upto 1k, 2nd from 1k-2k and so on. I want to write a macro which can lookup the correct approvers for me, satisfying all my conditions. Any help would be appreciable. Thanks in advance to all excel gurus/masters.
__________________
Regards Gaurav |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-4 conditions in a vlook-up
On Jan 12, 3:32*am, Gaura215 wrote:
I have an excel file, hich have Coloum like following: A - Business Unit; B - Doc Type; C - Amount I have another file which have the data for the approvers of the respective business unit & respective Doc type, and for amount pertaining to a range. For example for a particular business unit & documne type, there can be multiple approver, 1 can approve entries upto 1k, 2nd from 1k-2k and so on. I want to write a macro which can lookup the correct approvers for me, satisfying all my conditions. Any help would be appreciable. Thanks in advance to all excel gurus/masters. -- Gaura215 Contact me privately with an explanation and files dguillett1 @gmail.com |
#3
|
|||
|
|||
Quote:
__________________
Regards Gaurav |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlook UP | Excel Discussion (Misc queries) | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
how to do a Vlook up givin two conditions | Excel Worksheet Functions | |||
vlook up | Excel Worksheet Functions |