Hi Scott,

if I undestand your question you have

Col A Col B
1 John
2 Paul
3 Scott

and in another place you will have
Col A Col B
Scott Vlookup function to return 3

if it is correct my sugestion is create a C column on the original range
with =a2 (numbers) and copy it down (just to have the look figures on the
right column)

so the function should be =vlookup(a2,sheet1!b2:c100,2,0)

HTH
Regards from Brazil
Marcelo


"Scott" escreveu:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH