Index/Lookup

[jlkirk]

On sheet 1, column A1:A5, I have a list of names: Joe, Smith, Mary, Joan, Bill. Column B1:B5 of the same sheet contains reference codes for the names in A1:A5: JSM, SUT, MRE, KIT, and KTM.

On sheet 2, column B1:B5, I have a list of codes that includes some, but not necessarily all, the same codes that appear on sheet 1.

I would like to fill in sheet 2, column A1:A5 the names appearing on sheet 1 that correspond to the codes on sheet 2, column B1:B5.

Thanks in advance.

 

[Special-K99]

in Sheet2!B1
=IFERROR(VLOOKUP(B1,Sheet1!A$1:A$5,1,0),"***NOT FOUND***")

copy down column B

 

[Fluff]

Maybe

Book1
	A	B
1	Tom Pearce	Owner3
2	Bill Brewer	Owner4
3	Jan Stewer	Owner5
4	Peter Gurney	Owner6
5	Peter Davy	Owner7
Sheet1

Book1
	A	B
1	Tom Pearce	Owner3
2		Owner42
3	Jan Stewer	Owner5
4	Peter Gurney	Owner6
5	Peter Davy	Owner7
Sheet2

Cell Formulas
Range	Formula
A1	=IFERROR(INDEX(Sheet1!$A$1:$A$5,MATCH(B1,Sheet1!$B$1:$B$5,0)),"")

 

[jlkirk]

I cant get either to work. How do I get permission to post attachments?

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[jlkirk]

Thanks to all. I did finally get it to work.
Thanks again.

 

[Fluff]

Glad you sorted it & thanks for the feedback