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