**Question description:**

*This user has given permission to use the problem statement for this blog.*

i want to lookup a alphanumeric value(eg. EMP789 ) from a coloumn range
i use =VLOOKUP(REPT("z",255),C:C,1) to get text value

Solved by K. H. in 25 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
15/11/2017 - 06:16

hi there

Excelchat Expert
15/11/2017 - 06:17

just to clarify, u want to look up an alphanumeric value?

User
15/11/2017 - 06:18

HI'

User
15/11/2017 - 06:18

YA

User
15/11/2017 - 06:19

sumthng like EMP006

Excelchat Expert
15/11/2017 - 06:19

and the column range?

Excelchat Expert
15/11/2017 - 06:20

how does it look like?

User
15/11/2017 - 06:20

A

User
15/11/2017 - 06:20

A:A

Excelchat Expert
15/11/2017 - 06:21

where does rept come in?

User
15/11/2017 - 06:21

idk

Excelchat Expert
15/11/2017 - 06:21

is it possible if i can see the sheet?

User
15/11/2017 - 06:22

no sorry

User
15/11/2017 - 06:23

just want to find the last value in the coloumn

User
15/11/2017 - 06:23

the values in the coloumn are alphanumeric

Excelchat Expert
15/11/2017 - 06:24

can u see the sheet i opened?

Excelchat Expert
15/11/2017 - 06:24

im gonna use that as sample

User
15/11/2017 - 06:25

ok

Excelchat Expert
15/11/2017 - 06:25

can u add some more details?

Excelchat Expert
15/11/2017 - 06:26

so right now, the sample here is i want to find what is in cell a1, find its location in column c:c

Excelchat Expert
15/11/2017 - 06:26

is that similar to the formula u need?

Excelchat Expert
15/11/2017 - 06:28

pls take a look at column E

Excelchat Expert
15/11/2017 - 06:28

formula in e2 will give u which row it is found

Excelchat Expert
15/11/2017 - 06:29

is that how u wanted it done?

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*