Tricky one

[Daiwik]

Array
1	A
2	B
3	C
4	D
5	E
6	F
7	G
8	H
9	I

<colgroup><col><col></colgroup><tbody>
</tbody>

Lookup Value	Apply Vlookup only
Daiwik1	Daiwik1 value should be "A" and like wise
Daiwik2
Daiwik3
Daiwik4
Daiwik5
Daiwik6
Daiwik7
Daiwik8
Daiwik9

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[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)