I've got a spreadsheet #1 that refers to another spreadsheet #2.
This is what #1 looks like:
Null Null BCI BFI BCL
AUM
A/R
A/P
I want to fill #1 with the corresponding intersection values from #2 which looks like this
Null Null BFI BME BCL BCI
A/R
Salaries
Benefits
AUM
A/P
So, basically it's a simultaneous lookup from the column and row from Spreadsheet #1 to corresponding intersection from Spreadsheet #2. The position of the relative data from Spreadsheet #2 is not static - it comes from a database, so I can't reference cells statically.
Any thoughts?
Thanks!!
Chris.
This message was edited by cjordan on 2002-02-27 13:31
This message was edited by cjordan on 2002-02-27 13:37
This message was edited by cjordan on 2002-02-27 13:54
This is what #1 looks like:
Null Null BCI BFI BCL
AUM
A/R
A/P
I want to fill #1 with the corresponding intersection values from #2 which looks like this
Null Null BFI BME BCL BCI
A/R
Salaries
Benefits
AUM
A/P
So, basically it's a simultaneous lookup from the column and row from Spreadsheet #1 to corresponding intersection from Spreadsheet #2. The position of the relative data from Spreadsheet #2 is not static - it comes from a database, so I can't reference cells statically.
Any thoughts?
Thanks!!
Chris.
This message was edited by cjordan on 2002-02-27 13:31
This message was edited by cjordan on 2002-02-27 13:37
This message was edited by cjordan on 2002-02-27 13:54