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