Vlookup Help

[WRC]

In Cell A1=MID($B5,COLUMN(B1),1) (To split contains of one cell to many cells)

I am Refering the A1 to a 2 column table to get value using

A2 = =VLOOKUP (A1, E2:F11,2)

I get a error #NA

Pls. help

 

[T. Valko]

In Cell A1=MID($B5,COLUMN(B1),1)

A2 = =VLOOKUP (A1, E2:F11,2)

What's in B5?

If the result in cell A1 is supposed to be a numeric value use this:

=--MID($B5,COLUMN(B1),1)

 

[Sheeloo]

If you have an exact match in Col E for the value in A1
then use
A2 =VLOOKUP (A1, E2:F11,2,FALSE)

Otherwise values in Col E should be sorted in Increasing order.
(See VLOOKUP help for the meaning of the fourth parameter)

 

[WRC]

Let me explain:

A1=HBMY92LL10MH

B1=MID($A1,COLUMN(A1),1) To split contains of one cell to many cells)
C1=MID($A1,COLUMN(B1),1)
D1=MID($A1,COLUMN(B1),1)
E1=MID($A1,COLUMN(B1),1).
F1=MID($A1,COLUMN(B1),1)
...........etc

Next
I am using F2=Vlookup(F1:G20:H55,2)

NOTE: F1 is numeric value.

Thanks

 

[MyVeryOwnSelf]

I am Refering the A1 to a 2 column table to get value using

A1=HBMY92LL10MH

B1=MID($A1,COLUMN(A1),1) To split contains of one cell to many cells)
C1=MID($A1,COLUMN(B1),1)
..........etc

Next
I am using F2=Vlookup(F1:G20:H55,2)

NOTE: F1 is numeric value.

While it may be intuitive to think of F1 as numeric because it's a digit,
Excel considers it to be text because it's the result of MID(...).

This worked for me in Excel 2003:
=VLOOKUP(VALUE(F1),G20:H55,2)

 

[WRC]

Thanks Its works.

While it may be intuitive to think of F1 as numeric because it's a digit,
Excel considers it to be text because it's the result of MID(...).

This worked for me in Excel 2003:
=VLOOKUP(VALUE(F1),G20:H55,2)