Hi guys, as per title i need help regarding my formula. Attached excel file...
1. Input "HD50" until "HD5000" giving error "#VALUE!". Why is that happen, some others input all working fine..
for example:
A100 will show result 1A
HB300 will show 2A
Edit: Im sorry attaching wrong file...
More info on project:
Actually this project related to the library books call number. I want to create something so that user will easier search books belong to which shelf.
Column B and C is the Call Number (book reference number) and Column D represent Shelf Label.
Those inside excel only few database, i have alot more.. I know got some error... I'll try fix that later on..
1 shelf in the library have 2 side (1A and 1B), figure below..each side we label using call number (eg: G154 - HB171.5)
sNRPek7.jpg
So, let say user want to search book call number HB100, then they just input HB100, result will show this book shelve in which shelf.
Xn8xeF7.png
More sample INPUT vs RESULT
y873gvs.png
UPDATE: EXPECTED FINAL RESULT
Something like this, with other data cell will be hide and lock
ZMHlTtR.png
Bookmarks