G
Guest
=ISNUMBER(MATCH(RIGHT(F15,2)+0,$A$6:$E$10,0))+0
The formula above worked, I thought, but now for some reason I can't get
anything but zero. Here's a sample of sheet.
A B C D E F
50 45 48 49 55 752
60 65 58 59 66 0
70 75 68 69 77 1595
80 85 78 79 88 7355
90 95 98 89 99 7
Any help would be great Thank you!
Luke
The formula above worked, I thought, but now for some reason I can't get
anything but zero. Here's a sample of sheet.
A B C D E F
50 45 48 49 55 752
60 65 58 59 66 0
70 75 68 69 77 1595
80 85 78 79 88 7355
90 95 98 89 99 7
Any help would be great Thank you!
Luke