excel - Multiple IF for 430 argument -

excel - Multiple IF for 430 argument -

i have list of 430 rows set range of phone numbers in

**cabin to** cabin2 22007000 22009999 cabin3 22010000 22059999 cabin4 22060000 22075999 cabin5 22310000 22369999 cabin6 22370000 22377999 cabin7 22380000 22399999

and have 1500 phone number need set cabin belong need formula check number in range , print cabin name

**phone cabin** 22363998 cabin5 22365005 22381790 22381929 22478221 22478222

thanks on advance

you utilize index(cabinarray, match(phonenumber, numberfromarray, 1))

this match on highest value less than phonenumber lookup.

set cabin column named range cabinarray , from column numberfromarray.

note assumes ranges cover possible numbers , won't looking number outside range.

side note:

you utilize form of verification using more complex: if(index(cabinarray, match(phonenumber, numberfromarray, 1)) = index(cabinarray, match(phonenumber, numbertoarray, -1)), index(cabinarray, match(phonenumber, numberfromarray, 1)), "failed match")

this checks phonenumber looking both lower to , greater from. isn't elegant, work : )

excel