Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookups
All,
I have a worksheet full of data that is sorted by account number. I wasnt to write a lookup up formula that will look at the 'data tab' and if the account num,ber matches a certain account, then it will pull all of the information for that account number. For example, in colunm A there are a list of account numbers and from columns b thru z there is info. I want to write a formula that will lookup up the account number I want from column A and if it matches, give me all of the other info. Any and all help is greatly appreciated. Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookups
Hi Eric,
With the account numbers in A1, A2, etc: =VLOOKUP($A1,'Data Tab'!$A$1:$Y$3,COLUMN(B1),0) Copy to the right and, if needed, down (that is, if you have more than one account number to look up) -- Kind regards, Niek Otten Microsoft MVP - Excel "EC" wrote in message ... | All, | | I have a worksheet full of data that is sorted by account number. I wasnt | to write a lookup up formula that will look at the 'data tab' and if the | account num,ber matches a certain account, then it will pull all of the | information for that account number. For example, in colunm A there are a | list of account numbers and from columns b thru z there is info. I want to | write a formula that will lookup up the account number I want from column A | and if it matches, give me all of the other info. | | Any and all help is greatly appreciated. | | Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookups
Niek,
In column A I have the accounts numbers starting in cell A1 and continueing down through A24 and each account hase info going from Column B thru X. What i need to do is have the formula search from cell A1 to A24, and if it finds the account that matches up to the search criteria, take all the info from cloumn B thru column X and copy it to a certain range in the sheet. Eric "Niek Otten" wrote: Hi Eric, With the account numbers in A1, A2, etc: =VLOOKUP($A1,'Data Tab'!$A$1:$Y$3,COLUMN(B1),0) Copy to the right and, if needed, down (that is, if you have more than one account number to look up) -- Kind regards, Niek Otten Microsoft MVP - Excel "EC" wrote in message ... | All, | | I have a worksheet full of data that is sorted by account number. I wasnt | to write a lookup up formula that will look at the 'data tab' and if the | account num,ber matches a certain account, then it will pull all of the | information for that account number. For example, in colunm A there are a | list of account numbers and from columns b thru z there is info. I want to | write a formula that will lookup up the account number I want from column A | and if it matches, give me all of the other info. | | Any and all help is greatly appreciated. | | Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookups
Try the recipe I gave you. Strip the copying down if you don't need that.
-- Kind regards, Niek Otten Microsoft MVP - Excel "EC" wrote in message ... | Niek, | | In column A I have the accounts numbers starting in cell A1 and continueing | down through A24 and each account hase info going from Column B thru X. What | i need to do is have the formula search from cell A1 to A24, and if it finds | the account that matches up to the search criteria, take all the info from | cloumn B thru column X and copy it to a certain range in the sheet. | | Eric | | "Niek Otten" wrote: | | Hi Eric, | | With the account numbers in A1, A2, etc: | | =VLOOKUP($A1,'Data Tab'!$A$1:$Y$3,COLUMN(B1),0) | | Copy to the right and, if needed, down (that is, if you have more than one account number to look up) | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "EC" wrote in message ... | | All, | | | | I have a worksheet full of data that is sorted by account number. I wasnt | | to write a lookup up formula that will look at the 'data tab' and if the | | account num,ber matches a certain account, then it will pull all of the | | information for that account number. For example, in colunm A there are a | | list of account numbers and from columns b thru z there is info. I want to | | write a formula that will lookup up the account number I want from column A | | and if it matches, give me all of the other info. | | | | Any and all help is greatly appreciated. | | | | Eric | | | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookups
ok, I'll give it a shot. Ome other questions, on a different note. Lets say
I have a cell that has a whole bunhc of differents words in this 1 cell. Is there a way I can list these words in alphabetical order? Eric "EC" wrote: All, I have a worksheet full of data that is sorted by account number. I wasnt to write a lookup up formula that will look at the 'data tab' and if the account num,ber matches a certain account, then it will pull all of the information for that account number. For example, in colunm A there are a list of account numbers and from columns b thru z there is info. I want to write a formula that will lookup up the account number I want from column A and if it matches, give me all of the other info. Any and all help is greatly appreciated. Eric |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookups
Hi Eric,
On your last question: Use DataText to Columns, wit a space as separator. Then sort the columns (Options, Left to right) -- Kind regards, Niek Otten Microsoft MVP - Excel "EC" wrote in message ... | ok, I'll give it a shot. Ome other questions, on a different note. Lets say | I have a cell that has a whole bunhc of differents words in this 1 cell. Is | there a way I can list these words in alphabetical order? | | Eric | | "EC" wrote: | | All, | | I have a worksheet full of data that is sorted by account number. I wasnt | to write a lookup up formula that will look at the 'data tab' and if the | account num,ber matches a certain account, then it will pull all of the | information for that account number. For example, in colunm A there are a | list of account numbers and from columns b thru z there is info. I want to | write a formula that will lookup up the account number I want from column A | and if it matches, give me all of the other info. | | Any and all help is greatly appreciated. | | Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Crazy Lookups | Excel Worksheet Functions | |||
CAN DATES BE USED IN LOOKUPS? | Excel Discussion (Misc queries) | |||
Maybe I need help with Lookups?? | Excel Worksheet Functions | |||
Q: Using lookups to normalize a database? | Excel Discussion (Misc queries) | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |