IF (#Account No.) is between, cell A1 to cell B1, "Revenue", ...

[lampoonsaat]

Hi Guys, I'm trying to simplify a mapping table to use later as a vlookup.

The problem here is that I ranges defined by two different cells, as shown below:

A1 (from): 300001
B1 (to): 300999

Account type: "Revenues"

A2 (from): 301000
B2 (to): 302999

Account type: "Costs"

etc.

Do you have any idea how to solve this, because I cannot create a line for each account, it would be huge...

Cheers

[ben_hensel]

Is the Account type in C or what?

If so, you don't 100% need the B:B values, just use the trusty INDEX(MATCH):

=INDEX(C:C, MATCH(input_num, A:A, 1) )

[lampoonsaat]

Thanks dude, I didn't know that I can use a range instead of a unique number in onw of the variables of MATCH. Works great.