| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
