lookup multiple values in single cell

[boneshome]

Hello there -

Im looking for some help with a lookup.

I have two spreadsheets.

One with a simple list of numeric values:

Spreadsheet A

1004
24965
66435
25459
7785
1008
26885


The other has multiple values in a single cell:

Spreadsheet B

1004,24965,66435,25459
7785 1008 26885

The delimiter does vary, but it is always a non numeric.

Id like to be able to find the row number in spreadsheet B where m
value from Spreadsheet A appears.

Thanks very much for your time.

Andrew

 

[Jason Morin]

=MATCH("*"&A1&"*",rng,0)

where rng is the column with values on spreadsheet B.

HTH
Jason
Atlanta, GA