Hello, I have a problem with my lookup function. I know it has to do with my table not be sorted by ascending but I do not want to sort. I have a column with a list of devices with a column next to it with the serial numbers. I am using a drop down to select the device that returns the deivce name in cell a10 and the serial number in cell a11. Column 1 range name is device and column 2 range name is serial_no. Any help would be great!
PS, how do I attach an excel workbook to my post?
PS, how do I attach an excel workbook to my post?