Hi Becky

I put the values nb, 3m etc in G1:G4, then used this formula in H1

=INDEX($C:$C,MATCH("*"&G1,$B:$B,0))
and copy down
--
Regards
Roger Govier

BeckyB wrote:
This is the data to search for in the formulas (each is a different column):

Style# Item Description Item #
115-680G TRY FOOTSI SNP GREEN NB 02339660-9
115-680G TRY FOOTSI SNP GREEN 3M 02339661-7
115-680G TRY FOOTSI SNP GREEN 6M 02339662-5
115-680G TRY FOOTSI SNP GREEN 9M 02339663-3


This is where I need it to go (this is where I put the formulas):

115-680G
nb (Item#)
3m (Item#)
6m (Item#)
9m (Item#)


"Eduardo" wrote:

Hi,
Could you post an example of your data and what you want to achieve, thanks

"BeckyB" wrote:

I need help wrinting a formula for the below.

Sheet 1
A1=Style Number
B1=Size (text value)
C1=part number (formula result)

Sheet2 contains the data.
There are multiple entries of the style number (A1) on sheet 2. The size is
actually part of the TEXT description of that style. I need the formula to
give me the part number of that Size in that Style number.

Is there a way to write the formula to look for the Style number, then look
in that description for the text value and when they match, give me the part
number 1 column over?