jjxia2001
asked on
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
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
Can you do this with the standard VLOOKUP function?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent!