|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 16th, 2002, 04:00 PM
|
#1 |
|
Board Regular
Join Date: Mar 2002
Location: California
Posts: 105
|
Is there a way to lookup a 4 digit number and from the table the lookup will find the 4 digit number and count over 3 and that number is 4 digits but I only want the first three digits of that number
Vlookup(a1,range,3,false) the 3 (column index number)is the question when it counts over three to pull that number its 4 digits but I want the first three only Thanks! |
|
|
|
Apr 16th, 2002, 04:04 PM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Monterrey, Mexico
Posts: 1,433
|
Try the following:
=LEFT(VLOOKUP(A1,A:D,4),3) Where A:D is your range.
__________________
Kind regards, Al Chara |
|
|
|
|
Apr 16th, 2002, 04:05 PM
|
#3 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,318
|
Quote:
|
|
|
|
|
|
Apr 16th, 2002, 04:20 PM
|
#4 |
|
Board Regular
Join Date: Mar 2002
Location: California
Posts: 105
|
here is the number I'm looking up
7218 when it finds 7218 in the table it will count over three then pull that number. The number it pulls is YVR1 for example I want just YVR to be pulled Hope that makes sense |
|
|
|
|
Apr 16th, 2002, 04:21 PM
|
#5 |
|
Board Regular
Join Date: Mar 2002
Location: California
Posts: 105
|
it worked thanks AL
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
