Megan ... Forget my other post ... I reversed the values:

Assuming you have headings in Row 1

Try ... =vlookup(WS1$B2,WS2$J$2:$V$10,13,0)

Adjust Range J2:V10 as necessary ... Then copy down ... Kha

"Megan" wrote:

I have tried this but it brings back NA instead of the info.

Any ideas?
--
Kind regards
Megan


"Binyaaust" wrote:

try this:

=VLOOKUP(Sheet1!B:B,Sheet2!J:V,13,0)

"Megan" wrote:

I need the correct formula for the following problem I am experiencing.

If the reference number on sheet 1 column B matches the reference number in
column J on sheet 2 then transfer the data on sheet 2 column V.

Can anyone help please?

Kind regards
Megan