VLOOKUP Issues

[MWilliams]

Hello everyone,
I am sure that I would find the answer if I keep trying but I'm running out of time here.

I have two files and need to combine them.
One file contains a reference (Item-ID) to records (Item-ID, Item Name and Category) found in the other file.

There could be multiple references to the same record. I want to copy the records over. I hope the screenshot of this scenario will help.

(I can also copy the data from File B to another sheet in File A...

Thank you in advance for your suggestions.

 

[StephenCrump]

There will be different ways to do this.

To do it quickly, I'd
- put A and B in the same workbook
- insert two columns in A
- use a VLOOKUP formula (or XLOOKUP both columns in one go, if you have the XLOOKUP function)
- copy the two columns of formula cells and paste as values
- delete B

	A	B	C	D	E	F	G	H	I	J	K
1	Item			Data-2	Data-3	Data-4			Source B
2	17	Apples	Fruit	Blah	Blah	Blah			17	Apples	Fruit
3	18	Pears	Fruit	Blah	Blah	Blah			18	Pears	Fruit
4	18	Pears	Fruit	Blah	Blah	Blah			19	Grapes	Fruit
5	19	Grapes	Fruit	Blah	Blah	Blah			20	Bananas	Fruit
6	20	Bananas	Fruit	Blah	Blah	Blah			21	Watermelon	Fruit
7	20	Bananas	Fruit	Blah	Blah	Blah
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=VLOOKUP($A2,$I$2:$K$6,2,)
C2:C7	C2	=VLOOKUP($A2,$I$2:$K$6,3,)

 

[MWilliams]

Thank you very much!
I eventually figured out that the data in one of my ID columns was "a number stored as text" and as soon as I converted it to a number, the formula worked properly!
Thanks for your help. Greatly appreciated.

 

[StephenCrump]

Great, I'm glad it's working for you.