VBA for index match and an IF statement to make a cumbersome formula easier

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi All,
Looking for some assistance. built an Index Match that works great -
but I need to incorporate an IF statement based on varying levels of
revenue.

so here is the original formula:
=IF(ISERROR(INDEX(accountstaff,MATCH(B$20,INDEX(accountstaff,,1),0),MATCH($A55,INDEX(accountstaff,1,),0))),0,INDEX(accountstaff,MATCH(B$20,INDEX(accountstaff,,1),0),MATCH($A55,INDEX(accountstaff,1,),0)))

B20 being a dollar value
A sample of the table looks like this
column A column B Column C
Monthly Revenue Account Director Account Manager
83,333 0 1
166,667 0 0

so, we are looking for how many staff are associate with a particular
level of revenue.

Here is where I need the IF statement and am wondering if VBA will do
the trick and what the code would be.
I want to incorporate an IF for = or > each of the levels of revenue so
basically I am looking for this:

IF (revenue =<83,000, then match the job title and return the number of
staff under that title
IF (revenue = < 166,667 then match the job title and return the number
of staff under that title

so on and so forth

thanks in advance for any assistance out there!

.

Relevant Pages

  • Re: VBA for index match and an IF statement to make a cumbersome formula easier
    ... Perhaps use a pivot table and group on revenue. ... built an Index Match that works great - ... we are looking for how many staff are associate with a particular ... I want to incorporate an IF for = or> each of the levels of revenue so ...
    (microsoft.public.excel.programming)
  • Re: Paypal phone number?
    ... DDI numbers for staff. ... employees are making £30K a year, ... And perhaps you have a better idea how many hours a day they sit on paid-for incoming calls, or how much inbound revenue their 0870 number was chalking up. ...
    (uk.people.consumers.ebay)
  • Re: Paypal phone number?
    ... DDI numbers for staff. ... great deal of revenue. ... It's a nasty hidden way of getting dosh from people ...
    (uk.people.consumers.ebay)
  • Re: An expensive day for some...
    ... because providing staff would cost more than ... the revenue, or because staff are unable or unwilling to carry out ...
    (uk.railway)