Lookup formula to find names.

Closed
mekko
Posts
2
Registration date
Monday May 8, 2017
Status
Member
Last seen
May 8, 2017
- Updated on May 8, 2017 at 07:20 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- May 8, 2017 at 10:59 AM
Hi All,

Thanks for your time.

column C is from 1 to 12
column D is an amount

I have a table of numbers which categorized the numbers with specified amount and categorized person (column H, K & L)

EX: If (1) with a range of amount from ( 0 to 13,000) it will be with Senior 1

if (1) with a range of amount from ( 0 to 19,000) it will be with Senior 2

so, I have this table with 12 numbers and each number contain 9 ranges of amounts with difference names

can anyone help with an equation that can lookup column C and D with K and L to find the name in column H.

best wishes

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
May 8, 2017 at 10:59 AM
mekko, Good morning.

As are many details, it becomes more difficult to help quickly without a real example.

Please save an example of your spreadsheet on a free website, www.sendspace.com and place the link here for download.

Put at least one real example and what the expected result would be.
Do this manually.

So we can understand the layout of the spreadsheet and create the formulas to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0