Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup to extract part cell content
hi all,
how to apply the formula =vlookup(A1,subjectArray,3) to read only part of the cell in column 3 (say four digits from left). i tried =vlookup(A1,subjectArray,left(3,4)). the result was the entire value of that cell for example 123456789 and not 1234. thanks for any help |
#2
|
|||
|
|||
Hi!
Try this: =--LEFT(vlookup(A1,subjectArray,3),4) Biff -----Original Message----- hi all, how to apply the formula =vlookup(A1,subjectArray,3) to read only part of the cell in column 3 (say four digits from left). i tried =vlookup(A1,subjectArray,left(3,4)). the result was the entire value of that cell for example 123456789 and not 1234. thanks for any help . |
#3
|
|||
|
|||
many thanks Biff
excellent "Biff" wrote: Hi! Try this: =--LEFT(vlookup(A1,subjectArray,3),4) Biff -----Original Message----- hi all, how to apply the formula =vlookup(A1,subjectArray,3) to read only part of the cell in column 3 (say four digits from left). i tried =vlookup(A1,subjectArray,left(3,4)). the result was the entire value of that cell for example 123456789 and not 1234. thanks for any help . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |