Forum Discussion
Solved
Help with Formula
I am looking for help with creating a formula. I have added an example link below. In my example I am needing to be able to look at the income listed in column C compared to the Size of Household in...
=IF(VLOOKUP(D2,CHOOSE({1,2},{1;2;3;4;5;6;7;8},{27180;36620;46060;55500;64940;73480;83820;93260}),2,TRUE)>=C2,"yes","no")You can try this formula if you don't have the income guidelines listed in an Excel sheet.
=IF(VLOOKUP(D2,CHOOSE({1,2},{1;2;3;4;5;6;7;8},{27180;36620;46060;55500;64940;73480;83820;93260}),2,TRUE)>=C2,"yes","no")You can try this formula if you don't have the income guidelines listed in an Excel sheet.
- This worked perfect.. Thank you!!