# Lookup formula to find names.

Closed
mekko Posts 1 Registration date Monday May 8, 2017 Status Member Last seen May 8, 2017 - Updated on May 8, 2017 at 07:20 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 8, 2017 at 10:59 AM
Hi All,

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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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.