J
jin
I am trying to create associations between multiple alphanumeric code
and a single alphanumeric code. For example, I would like AT202B a
well as S76_305 to reference to a single row in a separate exce
workbook, where the entry in column A of that row would be the same (o
similar) to the name of the entire row, say AB1234_. The row would b
part of a table that has numerical data relevant to AB1234, i.e. eac
column is a different numerical aspect, such as part number, width
length, weight, etc. for columns A, B, C, and D, respectively.
I know that the name function in Excel can be used to create th
references (i.e. AT202B refers to AB1234) but I'm not sure if that i
exactly correct if I want to use the reference from a differen
workbook.
Mainly, I want to know how do I do this in a function? i.e. If cell A1
contains the number 1.45, how would I multiply cell A10 in the curren
workbook with a cell OR cells from a different workbook, given AT202B
How to reference/link/associate/whatever? Thanks
and a single alphanumeric code. For example, I would like AT202B a
well as S76_305 to reference to a single row in a separate exce
workbook, where the entry in column A of that row would be the same (o
similar) to the name of the entire row, say AB1234_. The row would b
part of a table that has numerical data relevant to AB1234, i.e. eac
column is a different numerical aspect, such as part number, width
length, weight, etc. for columns A, B, C, and D, respectively.
I know that the name function in Excel can be used to create th
references (i.e. AT202B refers to AB1234) but I'm not sure if that i
exactly correct if I want to use the reference from a differen
workbook.
Mainly, I want to know how do I do this in a function? i.e. If cell A1
contains the number 1.45, how would I multiply cell A10 in the curren
workbook with a cell OR cells from a different workbook, given AT202B
How to reference/link/associate/whatever? Thanks