Try:
=VLOOKUP(TEXT(J5,"00000"),'Ship List'!A$1:B$30,2,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joe M." wrote:
Also I am using =VLOOKUP(J5,'Ship List'!A$1:B$30,2,FALSE) to look in column A
on another worksheet (Ship List) and return the value in column B. I have
successfully used vlookup before. Column A in Ship List is sorted and I have
tried formatting both the lookup value and Col A from the lookup array as
text, general, number. However only a few cells return matches. Also I have
made sure the lookup val and Col A are the same length. The lookup value is a
5 digit number. Any ideas?
Thanks,
Joe M.