Remember Me?

 Posts: n/a vlookup

How can I make this work?
I have a worksheet. I need to extract the first two digits of a number. The
two digit number determines which equipment to use.That number checks
against a vlookup table and then the equipment is entered in another cell.
The worksheet is much larger than this but this should give you an idea what
the problem is.

Example:
A1 = 8110332
B1 =LEFT(A1,2) B1 now shows 81
C1 =VLOOKUP(B1,D1:E1,2,FALSE)
D1 =81
E1 =Thingy

The #N/A error shows. I just need to enter the number in A1 and all the rest
is done for me. I know the problem rests with the formula in B1.

 Peo Sjoblom Posts: n/a vlookup

Try

=VLOOKUP(--B1,D1:E1,2,FALSE)

or in B1 use

=--LEFT(A1,2)

then use your vlookup as originally stated

all the text functions return a text string

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

wrote in message
. net...
How can I make this work?
I have a worksheet. I need to extract the first two digits of a number.
The two digit number determines which equipment to use.That number checks
against a vlookup table and then the equipment is entered in another cell.
The worksheet is much larger than this but this should give you an idea
what the problem is.

Example:
A1 = 8110332
B1 =LEFT(A1,2) B1 now shows 81
C1 =VLOOKUP(B1,D1:E1,2,FALSE)
D1 =81
E1 =Thingy

The #N/A error shows. I just need to enter the number in A1 and all the
rest is done for me. I know the problem rests with the formula in B1.

 Max Posts: n/a vlookup

B1 =LEFT(A1,2) B1 now shows 81
C1 =VLOOKUP(B1,D1:E1,2,FALSE)

The "+0" will coerce the text number
returned by LEFTinto a real number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
How can I make this work?
I have a worksheet. I need to extract the first two digits of a number. The
two digit number determines which equipment to use.That number checks
against a vlookup table and then the equipment is entered in another cell.
The worksheet is much larger than this but this should give you an idea what
the problem is.

Example:
A1 = 8110332
B1 =LEFT(A1,2) B1 now shows 81
C1 =VLOOKUP(B1,D1:E1,2,FALSE)
D1 =81
E1 =Thingy

The #N/A error shows. I just need to enter the number in A1 and all the rest
is done for me. I know the problem rests with the formula in B1.

 Posts: n/a vlookup

Thank You So Much. Exactly What I Wanted.

"Max" wrote in message
...
B1 =LEFT(A1,2) B1 now shows 81
C1 =VLOOKUP(B1,D1:E1,2,FALSE)

The "+0" will coerce the text number
returned by LEFTinto a real number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
How can I make this work?
I have a worksheet. I need to extract the first two digits of a number.
The
two digit number determines which equipment to use.That number checks
against a vlookup table and then the equipment is entered in another
cell.
The worksheet is much larger than this but this should give you an idea
what
the problem is.

Example:
A1 = 8110332
B1 =LEFT(A1,2) B1 now shows 81
C1 =VLOOKUP(B1,D1:E1,2,FALSE)
D1 =81
E1 =Thingy

The #N/A error shows. I just need to enter the number in A1 and all the
rest
is done for me. I know the problem rests with the formula in B1.

 Max Posts: n/a vlookup

You're welcome ! Glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
et...
Thank You So Much. Exactly What I Wanted.

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Ian Excel Discussion (Misc queries) 3 April 6th 06 06:47 PM CornNiblet Excel Worksheet Functions 3 September 22nd 05 09:15 AM chris_manning Excel Worksheet Functions 2 August 9th 05 06:23 PM Mr Mike Excel Worksheet Functions 4 May 25th 05 04:51 PM Excel Worksheet Functions 0 January 26th 05 01:09 PM

All times are GMT +1. The time now is 11:37 AM. Copyright ©2004-2020 ExcelBanter.