Previous Topic Next Topic

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 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 - 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

Answer 1 / 1
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 146
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