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.