LinkBack URL
About LinkBacks
hi,
if i have a matrix that looks like the following (obviously larger)
Co Co Balance
1 2 9
1 3 10
1 4 10
2 1 10
2 3 9
Etc Etc, what formula can I enter to look up Company 1's balance with company 2 etc and return the value?????
hi,
if i have a matrix that looks like the following (obviously larger)
Co Co Balance
1 2 9
1 3 10
1 4 10
2 1 10
2 3 9
Etc Etc, what formula can I enter to look up Company 1's balance with company 2 etc and return the value?????
I donīt understand, can you show us an example?
See enclosed, i basically want a formula which returns the value of the interco balance with the co code (ie what value does the intercompany (column two) have with the company code (column one))?
Thanks
Your example is complicated by Col_A containing numeric text
and Col_B containing numbers.
Try this:
K1: Comp_1
L1: Comp_2
M1: I/C Balance
K2: (a company code....eg 101)
L2: (a company code....eg 111)
This ARRAY FORMULA, commited with CTRL+SHIFT+ENTER (instead of just ENTER) returns
the I/C Balance for those company codes.
List more company combinations and copy that formula down as far as you need. (see attached workbook)
Please Login or Register to view this content.
Does that help?
Last edited by Ron Coderre; 12-16-2008 at 11:09 AM. Reason: Add Array formula comment
***SOLVED*******
Hey,
That is perfect! Great bit of formula there, this has saved me an enormous amount of work! Much appreciated, thanks
Last edited by drreamsurfer; 01-05-2009 at 09:14 AM. Reason: SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks