Hello everyone, Good day,
I am searching a formula, sheet is attached. in R5=680, in S5 which formula should be write so that it find its matching / vlookup number from Z6:AA21
example, 250+220+170+120+80=680 so that in S5 answer should be P,O,M,K,H, cuz these alphabetic values are equal to R5 value.
Waiting for your guidline.
Thank you!
Bookmarks