I am trying to return the whole "number" (A123 and 0123). I have one
spreadsheet with Employee #s which matches them to their Manager. I have to
update this information on another spreadsheet.

Thank you

"trip_to_tokyo" wrote:

For the 2, "numbers" that you mention (A123 and 0123) what are you trying to
return from the VLOOKUP? Just the number 123 for both of them?

"PeterB" wrote:

I am attempting a V Lookup which involves Employee ID#'s, of which some begin
with a Letter (A123) and some begin with a Zero (0123). When I attempt to
convert these to Numbers I see no change and my V Lookup returns a #N/A
error. Any suggestions would be greatly appreciated.

Thank you