Lookup formula to find names.

[Closed]
Report
Posts
2
Registration date
Monday May 8, 2017
Status
Member
Last seen
May 8, 2017
-
Posts
1944
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2021
-
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

Posts
1944
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2021
145
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