Search data in different ranges

[ZHANG0]

Hi guys,

I have several dynamic ranges, name1, name2, name3,... I want to search data in these ranges based on the row of the cell.
for example, row 1~15 search name1, row 16~25 search name2, row 26~40 search name3,....

I know If function can do this, but whatabout if I have more than 10 ranges.

thanks in advance.

Zhang0

[[email protected]]

Use
=choose
function.

Regards,
Suhas

[ZHANG0]

yes, Choose function works.

thanks Suhas.