I've looked all through the posts and can't find a thread with a simliar issue. This is so stupid, and it's driving me crazy, but for the life of me, I can't figure it out and now it's giving me a headache. Here's the scenario: I have a cell which contains a product code number (the length can range from 3 digits to 6 digits). I have to search a data table where all of the numbers are formatted as 6 digits, hyphenated with a second set of digits. What I need to do is when the user enters the first set of digits in one cell, the function performs a LOOKUP to the data table, finds the entered 3-6 digit number within the column of 6 digit numbers (prior to the hyphenation), and retrieves the value in the column to the right (or left...I can move the columns) of the list of the 6 digit numbers. These columns can be formatted as numbers or text, it doesn't matter, but either way I format them, I can't get the dadgum LOOKUP (H and V included) function to work. Please help before I toss my laptop out the window of the 22nd floor.... sample view attached. THANK YOU.