Attached is an exact excerpt of the workbook I'm working with. Worksheet "Map" is where I'm working with the formulas. "Data" is where I'm attempting to pull the data from.
As stated previously, I've managed to pull 1400 and 1700 from range however the results were not correct. I believe I messed up while attempting to follow the formula provided and converting the table name and column name to range.
Also searching "1700" will include "1700-F" for some reason I cannot get it to search only "1700".
Bookmarks