3-4 conditions in a vlook-up

G

Gaura215

I have an excel file, hich have Coloum like following: A - Busines
Unit; B - Doc Type; C - Amount
I have another file which have the data for the approvers of th
respective business unit & respective Doc type, and for amoun
pertaining to a range. For example for a particular business unit
documne type, there can be multiple approver, 1 can approve entries upt
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
 
D

Don Guillett

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.

Contact me privately with an explanation and files dguillett1
@gmail.com
 
G

Gaura215

'Don Guillett[_2_ said:
;1109081']On Jan 12, 3:32*am, Gaura21
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 entrie upto
1k, 2nd from 1k-2k and so on.

I want to write a macro which can lookup the correct approvers fo me,
satisfying all my conditions.

Any help would be appreciable.

Thanks in advance to all excel gurus/masters.

Contact me privately with an explanation and files dguillett1
@gmail.com

Sent you an email from my email id, (e-mail address removed) with th
same subject line as of this post. Kindly revert on the same mail ID
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top