Vlookup

[lars]

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!

 

[Al Chara]

Try the following:

=LEFT(VLOOKUP(A1,A:D,4),3)

Where A:D is your range.

 

[Aladin Akyurek]

On 2002-04-16 15:00, lars wrote:
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!

Couldn't follow. Maybe you can give an example.

 

[lars]

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

 

[lars]

it worked thanks AL