Looking Up Content in a CELL

[Frank Kabel]

Hi
is there a logic at which place the numbers appear in one
of those cells. e.g. the first letter is always a
character?

-----Original Message-----
Is there any way I can look up content in a cell???

Iâ?Tve got two spreadsheets that I will use as an example:

Spreadsheet 1:
Has a cell witch contains the content x01234

Spreadsheet 2:
Has a cell which contains the content 01234AA01

The numbers are the same in each case. Is there any way

to match these two cells? I need to do this in order to
pull the cost that the second cell lists on Spreadsheet
2? Hopefully this is possible because I have hundreds of
these #â?Ts that I need to match and they are all like the
examples.

 

[Frank Kabel]

Hi
this is more complicated. Especially extractint the number
from your value.
But try the following array entered formula:
A1 and A3 are the two cells two compare (enter the formula
with CTRL+SHIFT+ENTER):
=COUNTIF(A3,"*"&MID(A1,MIN(IF(ISNUMBER(--MID
(A1,seq,1)),seq)),MAX(IF(ISNUMBER(--MID(A1,seq,1)),seq))-
MIN(IF(ISNUMBER(--MID(A1,seq,1)),seq))+1)&"*")

-----Original Message-----
no logic at all with the letters...sometimes there at the

beginning of the number, at the end of the number or both
at the beginning or end.

 

[Frank Kabel]

Hi
if a match is found it will return '1' if no match returned it returns
zero

 

[Frustrated Worker]

No dice...if you try the numbers that I listed in my example it brings up a 0. If needs to be a 1 because the part numbers are the same if the letters are not there. This is my problem...I can't get the two numbers to "talk to each other."

 

[Frank Kabel]

Hi
works for me. If you like, you can send me your file and I'll have a
look at it
email: frank[dot]kabel[at]freenet[dot]de

 

[Frank Kabel]

Hi
mail is on the way. I forgot that you also have to define the name
'seq' with the formula
=ROW(INDIRECT("1:1024"))

 

[Frustrated Worker]

Frank...I've been messing around with trying to use Macro's with that example I sent you, because I'm not at all familiar with them, and I can't get my spreadsheet to work..,suggestion as to how I should go about working on this project???

Thanks again!
Jared