If you want index 4, you must have at least 4 columns

=vlookup(a1,sheet1!a1:d863,4,false)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pierre Fichaud" wrote in message
...
=vlookup(a1,sheet1!a1:b863,4,false)

I get #REF.

I want the value in the 4th column in sheet1 to be inserted in the cell
when
any of A1 to b863 match a1.

PF.

Bob Phillips wrote:

=VLOOKUP(A1,Sheet2!A1:B100,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Pierre Fichaud" wrote in message
...
I have 2 sheets, The first sheet has coulmns 1 with a name and column
2
with a value. The second sheet has column 1 with a name and other
columns. Using the name in sheet2, I want to find an exact match with
a
name in column1 of sheet1 and then move the corresponding value in
column 2 of shhet 1 to sheet2. I think this can de done with VLOOKUP
but
I can't get past the second parameter. Can someone help me with this?
TIA. PF.