vlookup

R

r.gardiner

Using numbers (ie 2345 or 9874) vlookup works very well but when i use
alphanumeric(ie st345 or 5678y) it returns the value of the cell
directly above the correct one. the table is sorted ascendingly.
Please help.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Creating Auto Separation of Numbers thru Defining Delimiter 1
VLOOKUP Not working 3
sorting: cleared/null v/s "" 3
transformed vloopup 2
Vlookup to reference offset 1
Vlookup with alphanumeric values 4
VLookup help, or similar function help, Please! 2
Help With VLOOKUP 2

Top