Hi,

Am Fri, 15 Jun 2012 14:30:18 +0000 schrieb Perpmotion:

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.

in C2 try:
=INDEX($F$2:$F$100;VERGLEICH(WAHR;FINDEN(B2;$E$2:$ E$100)0;0))
It's an array formula to enter with CTRL+Shift+Enter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2