Tricky one

[Daiwik]

[TABLE="width: 156"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]Array[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]I[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 241"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Lookup Value[/TD]
[TD] Apply Vlookup only[/TD]
[/TR]
[TR]
[TD]Daiwik1[/TD]
[TD]
Daiwik1 value should be "A" and like wise[/TD]
[/TR]
[TR]
[TD]Daiwik2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Daiwik3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Daiwik4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Daiwik5[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Daiwik6[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Daiwik7[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Daiwik8[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Daiwik9[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Noodleski]

The request is lacking a clear question.
Assuming you want to extract the numeric value from the "Daiwik1" cell and use it as a vlookup reference? It is however unclear if you have other things besides Daiwik in those cells, if the numbers are limited to 1 digit values...

If daiwik is the only thing you'll ever have a formula such as below might suffice:
vlookup(right(A15,len(A15)-6)*1,A$1:B$10,2,0)

This assumes your array is in A1 to B10 and your values you want to look up start from A15.

 

[Daiwik]

Hi Noodleski, Question says to extract the numeric value from the "Daiwik1" cell and use it as a vlookup reference. However, numbers are limited to 1 digit values.
and vlookup(right(A15,len(A15)-6)*1,A$1:B$10,2,0) is working correct..

I too got it as vlookup(value(right(A15,1)),$A$1:$B$9,2,0)