i am working on a sheet using vlookup to find matching gender and shoe size with socks size. however i can only get the formula to work under the reference table. if the size is beyond or under the given size, it suppose to display too large or too small. i don't know how to add that condition to the formula, would you guys please help me. thank you.
i used =IF(C20="M",VLOOKUP(B20,mensocksize,2,TRUE),VLOOKUP(B20,womensocksize,2,TRUE)). i need a formula, not only look up the matching size, but also solve D20 and D21 as too big or too small.
Thank you so much. forum.ozgrid.com/index.php?attachment/38455/