need help to write a lookup formula in Excel

I have an Excel data set and I need decide which group each row ( have 10,000 rows) belongs to based on freq_factor field and use a mapping below.  How to write a formula in Excel to do it?  Thanks for helps!

freq_factor      Group
<=-0.07                      Emod_N_Group_1
<=-0.05                      Emod_N_Group_2
<=-0.04                      Emod_N_Group_3
<=-0.03                      Emod_N_Group_4
...
...
...
...                             Emod_N_Group_100
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Can you do this with the standard VLOOKUP function?
0
Commented:
What sort of values do you have in the freq_factor field in your dataset? If those are numbers then you can use a formula like this

=INDEX(F\$2:F\$5,COUNTIF(E\$2:E\$5,"<"&A2)+1)

where A2 is a specific freq_factor and E2:F2 is your table showing the relationship, see attached. You can expand the table as far as your want but I'm assuming that column E will list the boundaries in ascending order.

regards, barry
27496563.xls
0

Experts Exchange Solution brought to you by