Concatenating inside a single function


Posted by Jon Griggs on August 02, 2001 7:49 AM

I have two cells with the following (operational) code that I would like to combine. Bear with me...

Cell 1:
=HYPERLINK("[C:\Temp\PartsBook.xls] 'Parts Book'!A4162",E15)

Cell 2:
=MATCH(E15,'Parts Book'!A14:A15013,0)

Cell 2 reults in 4162, which is where the A4162 from cell 1 came from.

What I need to do is Combine A and the result of Cell2 to give me A4162. I then want to use that inside of Cell 1 to replace the A4162 in order to make it dynamic.

I tried to do that in the following, but it didn't work.
=HYPERLINK("[C:\Temp\PartsBook.xls] 'Parts Book'!A&(MATCH(E15,'Parts Book'!A14:A15013,0))",E15)

Any thoughts or suggestions?

I know this may be clear as mud, so if clarification is needed, please ask.

Thanks,
Jon Griggs

Posted by Aladin Akyurek on August 02, 2001 8:05 AM

Change this to:

=HYPERLINK("[C:\Temp\PartsBook.xls] 'Parts Book'!A"&MATCH(E15,'Parts Book'!A14:A15013,0))

Aladin



Posted by Aladin Akyurek on August 02, 2001 8:05 AM

Change this to:

=HYPERLINK("[C:\Temp\PartsBook.xls] 'Parts Book'!A"&MATCH(E15,'Parts Book'!A14:A15013,0))

Aladin