ExcelBanter - Is this Vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is this Vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/158458-vlookup.html)

To simplify my problem, I have 2 wooksheets. On sheet1 i have 2
columns that I need to reference. Col_B has old ref and Col_Z has new
ref.
While on Sheet2 I have Col_K which is the same as Col_B on shee1 (old
ref). Whilst they both contain the old ref numbers they are not in the
same order and indeed sheet2 has many old refs missing.
On sheet2 I need to create a new column (Col_M) which contains the New
Ref ie same as Col_Z on sheet1.
So I need to match Col_B (sheet1) with Col_K (sheet2) and then copy
over Col_Z (sheet1) to Col_M. (sheet2) What is the best way to achive
this please.

Bob

One way ..

In Sheet2,
Put in M1:
=IF(ISNA(MATCH(K1,Sheet1!B:B,0)),"",INDEX(Sheet1!Z :Z,MATCH(K1,Sheet1!B:B,0)))
Copy down as far as required.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Box666" wrote:
To simplify my problem, I have 2 wooksheets. On sheet1 i have 2
columns that I need to reference. Col_B has old ref and Col_Z has new
ref.
While on Sheet2 I have Col_K which is the same as Col_B on shee1 (old
ref). Whilst they both contain the old ref numbers they are not in the
same order and indeed sheet2 has many old refs missing.
On sheet2 I need to create a new column (Col_M) which contains the New
Ref ie same as Col_Z on sheet1.
So I need to match Col_B (sheet1) with Col_K (sheet2) and then copy
over Col_Z (sheet1) to Col_M. (sheet2) What is the best way to achive
this please.

Bob