I am a little confused. in sheet 2 in column b2 the name is let's say "john",
now in sheet one john could be in b108. I want thw funtion to find john in
sheet 1 and return the corresponding number in a108 on sheet 1 to a1 on sheet
two
--
SAH


"Marcelo" wrote:

Hi, Scott, it is sound strage.

try to check if the Johns are equal =sheet1!b2=B2 just to check it is true

"Scott" escreveu:

I tried it and it returns n/a
--
SAH


"Marcelo" wrote:

OK Scott, try this

First ws
Col a Col b Col C
1 John =A2 returns 1
2 Paul =A3 returns 2

second ws
Col A
Col B
=vlookup(B2,Sheet1!$B$2:$C$3,2,0) returns 1 John

HTH



"Scott" escreveu:

close
in your example

Col a Col b
1 John
2 Paul

are in a seprate worksheet


Then in the other worksheet it will look like this

Col A Col B
John
Paul



I want it to match John to John and return the value of 1 to Col A of the
second worksheet


--
SAH


"Marcelo" wrote:

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