Hi guys,
may i ask for your help what better formula can i make to solve this. my main objective is to - the cell highlighted in yellow should return the details from the "BOOK" column. If the serial number fall equal to "Start" or "End" or if it falls under between the range between the "Start" and "End",it should reflect the "Book" details.
Ex. if Serial# is 100002 , Book Column (highlighted in "yellow") should get "A" because it is between range of 100001 and 100100
sample.PNGsample.PNGsample.PNG
Bookmarks