Lottery Check with Winnings

so I have this sheet that I'm working on in which it will highlight which numbers you've matched. My main problem that I am having is that I also want it to tell you how much you've won. Anybody care to look at it and see where the problem may be coming from.

Originally Posted by sldfghtrike

so I have this sheet that I'm working on in which it will highlight which numbers you've matched. My main problem that I am having is that I also want it to tell you how much you've won. Anybody care to look at it and see where the problem may be coming from.

also, I should make it clear that I am referring to my "Winnings" column

Originally Posted by sldfghtrike

also, I should make it clear that I am referring to my "Winnings" column

Hi,

See attached.
Because the numbers showing how many matches (G5:H14) are generated by formulas, wrapping those references in VALUE() fixes the problem.

However, I've also included another worksheet that shows how I would do it personally. It involves one helper column that can be hidden and a MUCH shorter formula.

Hope that helps.

S

Originally Posted by Spencer101

Hi,

See attached.
Because the numbers showing how many matches (G5:H14) are generated by formulas, wrapping those references in VALUE() fixes the problem.

However, I've also included another worksheet that shows how I would do it personally. It involves one helper column that can be hidden and a MUCH shorter formula.

Hope that helps.

S

Thanks for explaining that VALUE function, you made it do exactly what I wanted

Also, I looked at your formula, that is much easier, I also learned what vlookup does, that is one very helpful function

Thanks a lot for your help.

Originally Posted by sldfghtrike

Thanks for explaining that VALUE function, you made it do exactly what I wanted

Also, I looked at your formula, that is much easier, I also learned what vlookup does, that is one very helpful function

Thanks a lot for your help.

Pleasure is all mine. Glad to help

sldfghtrike wrote:
> sldfghtrike;1604009 Wrote:
>> so I have this sheet that I'm working on in which it will highlight
>> which numbers you've matched. My main problem that I am having is that I
>> also want it to tell you how much you've won. Anybody care to look at it
>> and see where the problem may be coming from.
>
> also, I should make it clear that I am referring to my "Winnings" column
>
>
> +-------------------------------------------------------------------+
> +-------------------------------------------------------------------+
>
>
>

This works for me as a conditional format,
=NOT(ISERROR(HLOOKUP(D6,B3:G3,1,FALSE)))

Insert appropriate cell locations and then pick your font color when the
condition is true.

HTH