| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find values in a list of text fields
On sheet A I have account codes entered as numeric fields. On sheet B
I have a list of account codes (formatted as text) and their corresponding account name. Looking up the account code in sheet A I want to find that account code in sheet B and return the account name. How can I use a numeric field in A to find items that are formatted as text in sheet B? Thanks for any help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to find values in a list of text fields
If your account codes (formatted as text) are of fixed length (5 in my
example, "00000" represents five digits, change it to your needs!), ), try this: =VLOOKUP(TEXT(A2,"00000"),SheetB!A:B,2,FALSE) Regards, Stefi €ť ezt Ă*rta: On sheet A I have account codes entered as numeric fields. On sheet B I have a list of account codes (formatted as text) and their corresponding account name. Looking up the account code in sheet A I want to find that account code in sheet B and return the account name. How can I use a numeric field in A to find items that are formatted as text in sheet B? Thanks for any help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to find values in a list of text fields
On Jun 9, 2:43*pm, Stefi wrote:
If your account codes (formatted as text) are of fixed length (5 in my example, "00000" represents five digits, change it to your needs!), ), try this: =VLOOKUP(TEXT(A2,"00000"),SheetB!A:B,2,FALSE) Regards, Stefi ” ezt írta: On sheet A I have account codes entered as numeric fields. *On sheet B I have a list of account codes (formatted as text) and their corresponding account name. Looking up the account code in sheet A I want to find that account code in sheet B and return the account name. How can I use a numeric field in A to find items that are formatted as text in sheet B? Thanks for any help.- Hide quoted text - - Show quoted text - Works great except...the fields vary in length. Is there any way to make this element in the formula more dynamic? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to find values in a list of text fields
If I just change the formula to
=VLOOKUP(TEXT(A2,"0"),SheetB!A:B,2,FALSE) it will handle different length text strings. Excellent! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to find values in a list of text fields
Be careful! Yes, if you don't have leading zeros in codes in SheetB!A:B. No,
if you have! Stefi €ť ezt Ă*rta: If I just change the formula to =VLOOKUP(TEXT(A2,"0"),SheetB!A:B,2,FALSE) it will handle different length text strings. Excellent! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find & delete a particular pattern of text from values of a | Excel Discussion (Misc queries) | |||
| EXCEL: Truncating Text Fields to allow Vlookup searches to find da | Excel Worksheet Functions | |||
| How to find the values from a list? | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Assigning text values to numeric fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
