HELP! I have two worksheets. One is the Master Account list and the other is
the Aging. I have made it so both have the same column headings (Account,
Name, Addresss, current, 7-30, 30-60 etc). What I need to do is combing the
two so that the aging shows up on the Master in the row with the
corresponding account. However, there are many more accounts on the Master
than on the Aging so excel will need to look up or find the data.
I have tried Vlookup but I cant get it to work. I feel like I am missing a
crucial piece of info somewhere.


Any help would be appreciated. Hopefully I am making sense.

What is the error message you get?
would you post your formula
Generally, a Vlookup :
=VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)
= VLOOKUP(A2,Aging!A6:E6,4,0)

This will return extact current based on the Account which are on both Sheet
Col A

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Tessa" wrote:

HELP! I have two worksheets. One is the Master Account list and the other is
the Aging. I have made it so both have the same column headings (Account,
Name, Addresss, current, 7-30, 30-60 etc). What I need to do is combing the
two so that the aging shows up on the Master in the row with the
corresponding account. However, there are many more accounts on the Master
than on the Aging so excel will need to look up or find the data.
I have tried Vlookup but I cant get it to work. I feel like I am missing a
crucial piece of info somewhere.


Any help would be appreciated. Hopefully I am making sense.

My formula is as follows...
=VLOOKUP(A155,Aging!A2:A445,9,0)

It returns a #REF! error. I want it to pull the value for Colum I from
Aging for the account number in A155.
I confirmed that there is a number in this colum.


"Francis" wrote:

What is the error message you get?
would you post your formula
Generally, a Vlookup :
=VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)
= VLOOKUP(A2,Aging!A6:E6,4,0)

This will return extact current based on the Account which are on both Sheet
Col A

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Tessa" wrote:

HELP! I have two worksheets. One is the Master Account list and the other is
the Aging. I have made it so both have the same column headings (Account,
Name, Addresss, current, 7-30, 30-60 etc). What I need to do is combing the
two so that the aging shows up on the Master in the row with the
corresponding account. However, there are many more accounts on the Master
than on the Aging so excel will need to look up or find the data.
I have tried Vlookup but I cant get it to work. I feel like I am missing a
crucial piece of info somewhere.


Any help would be appreciated. Hopefully I am making sense.

You have to make the lookup range at least 9 columns:

A2:A445 is only one.

=VLOOKUP(A155,Aging!A2:i445,9,0)

May be enough.

Tessa wrote:

My formula is as follows...
=VLOOKUP(A155,Aging!A2:A445,9,0)

It returns a #REF! error. I want it to pull the value for Colum I from
Aging for the account number in A155.
I confirmed that there is a number in this colum.

"Francis" wrote:

What is the error message you get?
would you post your formula
Generally, a Vlookup :
=VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)
= VLOOKUP(A2,Aging!A6:E6,4,0)

This will return extact current based on the Account which are on both Sheet
Col A

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Tessa" wrote:

HELP! I have two worksheets. One is the Master Account list and the other is
the Aging. I have made it so both have the same column headings (Account,
Name, Addresss, current, 7-30, 30-60 etc). What I need to do is combing the
two so that the aging shows up on the Master in the row with the
corresponding account. However, there are many more accounts on the Master
than on the Aging so excel will need to look up or find the data.
I have tried Vlookup but I cant get it to work. I feel like I am missing a
crucial piece of info somewhere.


Any help would be appreciated. Hopefully I am making sense.



--

Dave Peterson