| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLookup a portion of a no. in a cell
Can I do a vlookup on the 1st 2 no. of a 6 digits no.? Eg.
Table 1 Postal Code Area 200455 ? Table 2 Postal Code Area 20 A I want table 1 to reflect A |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vLookup a portion of a no. in a cell
Maybe something like this:
=VLOOKUP(--LEFT(A2,2),Table2,2,0) -- Biff Microsoft Excel MVP "kattay" wrote in message ... Can I do a vlookup on the 1st 2 no. of a 6 digits no.? Eg. Table 1 Postal Code Area 200455 ? Table 2 Postal Code Area 20 A I want table 1 to reflect A |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vLookup a portion of a no. in a cell
Hi, thanks. It worked.
I guess the 2 in "--LEFT(A2,2)" refers to the no. of digits I want to lookup. What about "--", does it denotes anything? "T. Valko" wrote: Maybe something like this: =VLOOKUP(--LEFT(A2,2),Table2,2,0) -- Biff Microsoft Excel MVP "kattay" wrote in message ... Can I do a vlookup on the 1st 2 no. of a 6 digits no.? Eg. Table 1 Postal Code Area 200455 ? Table 2 Postal Code Area 20 A I want table 1 to reflect A |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vLookup a portion of a no. in a cell
I guess the 2 in "--LEFT(A2,2)" refers to the no.
of digits I want to lookup Yes What about "--", does it denotes anything? The LEFT function is a text function and as such returns a *TEXT* value. The double unary is one method of coercing the text result of 20 to the numeric result of 20 so that you have matching data types between the lookup value and the data in the lookup table. TEXT 20 and numeric 20 aren't the same to Excel. -- Biff Microsoft Excel MVP "kattay" wrote in message ... Hi, thanks. It worked. I guess the 2 in "--LEFT(A2,2)" refers to the no. of digits I want to lookup. What about "--", does it denotes anything? "T. Valko" wrote: Maybe something like this: =VLOOKUP(--LEFT(A2,2),Table2,2,0) -- Biff Microsoft Excel MVP "kattay" wrote in message ... Can I do a vlookup on the 1st 2 no. of a 6 digits no.? Eg. Table 1 Postal Code Area 200455 ? Table 2 Postal Code Area 20 A I want table 1 to reflect A |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract portion of a cell | Excel Discussion (Misc queries) | |||
| Formula to multiply only a portion of a cell number? | Excel Worksheet Functions | |||
| A formula for moving a portion of a cell??? | Excel Discussion (Misc queries) | |||
| return a portion of data entered into a cell | Excel Discussion (Misc queries) | |||
| formaula used to abstract portion of a cell to another cell | Excel Worksheet Functions | |||
Linear Mode
