B
Bud Fina
I have inherited a convoluted worksheet that I need to reference to a complex sheet that I cannot manipulate. The data I need is in the latter sheet. It has several entries for single accounts that I need to pull into the first sheet. i.e.:
Account 4DigitCode Amount1 Amount2
345678 0200 $1000.00 $456.89
345678 7820 $17.89 $17256.01
022789 0200 $10.00 $0.00
022789 1111 $0.00 $500.00
I need to display each amount by 4DigitCode for each account. I thought I could concatenate the account and 4DigitCode in a vlookup, I could have write a formula to lookup the concatenated value and place the two amounts in the new sheet. It didn't work, so I also concatenated the fields in the sheet I want the data to go in (ConcDesired) and tried to vlookup using that field referencing the first vlookup. i.e.
Vlookup1 (Complex Sheet)
Account 4DigitCode Concatenate
345678 0200 3456780200
345678 7820 3456787820
022789 0200 0227890200
022789 1111 0227891111
my formula: VLOOKUP(M7,SLLookup,4,FALSE) returns "#Value"
and VLOOKUP(M7,SLLookup,4,True) returns zeros for everything
where M7 is the cell that had the ConcDesired value and SLLookup is the vlookup table.
Is what I want possible? If yes, how do I make it work?
Account 4DigitCode Amount1 Amount2
345678 0200 $1000.00 $456.89
345678 7820 $17.89 $17256.01
022789 0200 $10.00 $0.00
022789 1111 $0.00 $500.00
I need to display each amount by 4DigitCode for each account. I thought I could concatenate the account and 4DigitCode in a vlookup, I could have write a formula to lookup the concatenated value and place the two amounts in the new sheet. It didn't work, so I also concatenated the fields in the sheet I want the data to go in (ConcDesired) and tried to vlookup using that field referencing the first vlookup. i.e.
Vlookup1 (Complex Sheet)
Account 4DigitCode Concatenate
345678 0200 3456780200
345678 7820 3456787820
022789 0200 0227890200
022789 1111 0227891111
my formula: VLOOKUP(M7,SLLookup,4,FALSE) returns "#Value"
and VLOOKUP(M7,SLLookup,4,True) returns zeros for everything
where M7 is the cell that had the ConcDesired value and SLLookup is the vlookup table.
Is what I want possible? If yes, how do I make it work?