Forum Discussion

michael pitre's avatar
michael pitre
Copper Contributor
May 11, 2018

Income Table with multiple look up and highlight answer

Hello,

  I have a income table that I'd I'm having trouble automating. It should work by my employees filling in the "house hold" size in cell A14 and Income amount in B14. This would determine the tier of Free, Reduced, or Paid in cell C14.  I can use =IF(B14<B5,"Free",IF(B14>=C5,"Paid","Reduced")) but that's not going to work for an array.  I haven't figured out how to convert this to an index/match and I don't think Vlookup would work, but that's why I thought I'd ask the group. Any suggestions are greatly appreciated. Thanks for taking time to read my post.

 

No RepliesBe the first to reply

Resources