Looking Up Content in a CELL

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

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
Click to expand...
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.
 
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
Click to expand...
beginning of the number, at the end of the number or both
at the beginning or end.
 
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."
 
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
 
Hi
mail is on the way. I forgot that you also have to define the name
'seq' with the formula
=ROW(INDIRECT("1:1024"))
 
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
 
Back
Top