If value in two columns match, return values from other columns

[LostinVA]

Hi everyone -

I'm trying to figure out how to compare values from Sheet1, Column A and Sheet 2, Column B, and if they match to return the values from Sheet2, Columns F, G, and I to Sheet1, Columns F, G, and H.

Confused yet? Hopefully that makes sense. Doesn't seem like it should be too complicated I just can't figure it out.

Thank you in advance!

 

[kweaver]

It would help if you posted some sample data using XL2BB.

 

[LostinVA]

It would help if you posted some sample data using XL2BB.

Sorry, sample data below. Also, I mis-typed the comparison columns. This is what I'm looking to do: Compare values from Sheet1, Column A and Sheet 2, Column A, and if they match to return the values from Sheet2, Columns F, G, and I to Sheet1, Columns F, G, and H.

Sheet1:

Granite v C2F DIA 10Mb 12 Month.xlsx
	A	B	C	D	E	F	G	H
1	Address	Carrier	Service	MRC	NRC	C2F Supplier	MRC	NRC
2	100 HUNTINGTON AVE, BOSTON, MA 02116	Granite Grid	Grid FE - 10Mbps	360	1250
Granite

Sheet2:

Granite v C2F DIA 10Mb 12 Month.xlsx
	A	B	C	D	E	F	G	H	I
1	Address	City	State	Zipcode	Country	MRC	NRC	Term	Supplier
2	333 Canal St	New Orleans	LA	70130	USA	565	500	12	Cox Communications
C2F Low Rate

Thanks!

 

[kweaver]

Well, this little data, I would have to assume you mean a row-by-row comparison that would look like this:

Book1
	A	B	C	D	E	F	G	H
1	Address	Carrier	Service	MRC	NRC	C2F Supplier	MRC	NRC
2	100 HUNTINGTON AVE, BOSTON, MA 02116	Granite Grid	Grid FE - 10Mbps	360	1250
3	1 Main Street	Whatever	Grid AA	100	200	AT&T	999	888
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=IF($A2=Sheet2!$A2,Sheet2!I2,"")
G2:H3	G2	=IF($A2=Sheet2!$A2,Sheet2!F2,"")

Book1
	A	B	C	D	E	F	G	H	I
1	Address	City	State	Zipcode	Country	MRC	NRC	Term	Supplier
2	333 Canal St	New Orleans	LA	70130	USA	565	500	12	Cox Communications
3	1 Main Street					999	888		AT&T
Sheet2

 

[LostinVA]

Well, this little data, I would have to assume you mean a row-by-row comparison that would look like this:

Book1
	A	B	C	D	E	F	G	H
1	Address	Carrier	Service	MRC	NRC	C2F Supplier	MRC	NRC
2	100 HUNTINGTON AVE, BOSTON, MA 02116	Granite Grid	Grid FE - 10Mbps	360	1250
3	1 Main Street	Whatever	Grid AA	100	200	AT&T	999	888
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=IF($A2=Sheet2!$A2,Sheet2!I2,"")
G2:H3	G2	=IF($A2=Sheet2!$A2,Sheet2!F2,"")

Book1
	A	B	C	D	E	F	G	H	I
1	Address	City	State	Zipcode	Country	MRC	NRC	Term	Supplier
2	333 Canal St	New Orleans	LA	70130	USA	565	500	12	Cox Communications
3	1 Main Street					999	888		AT&T
Sheet2

Thanks for taking a look at it for me. There is a lot more data but I figured only the column headers and one row of data would be necessary to determine formulas. The formulas appear to just return what is in Column I & F from Sheet2.. it should only return a value when there's a match between Column A from Sheet1 and Column A from Sheet2. So if the addresses match, then populate Columns F, G, and H on Sheet1 with data from Columns F, G, and I from Sheet2.

 

[kweaver]

That's what the formulas did, I thought...when the addresses match, the data was copied. Otherwise, nothing was done.
If you provide a bit more data and what you expect when there's a match, that would help.

Maybe you don't mean row-by-row, but I'm only guessing with only 1 line of data per sheet.

Is this what you mean?

Book1
	A	B	C	D	E	F	G	H
1	Address	Carrier	Service	MRC	NRC	C2F Supplier	MRC	NRC
2	100 HUNTINGTON AVE, BOSTON, MA 02116	Granite Grid	Grid FE - 10Mbps	360	1250	Sprint	1010	2020
3	1 Main Street	Whatever	Grid AA	100	200	AT&T	999	888
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=VLOOKUP($A2,Sheet2!$A$2:$I$100,9,FALSE)
G2:G3	G2	=VLOOKUP($A2,Sheet2!$A$2:$I$100,6,FALSE)
H2:H3	H2	=VLOOKUP($A2,Sheet2!$A$2:$I$100,7,FALSE)

Book1
	A	B	C	D	E	F	G	H	I
1	Address	City	State	Zipcode	Country	MRC	NRC	Term	Supplier
2	333 Canal St	New Orleans	LA	70130	USA	565	500	12	Cox Communications
3	1 Main Street					999	888		AT&T
4	100 HUNTINGTON AVE, BOSTON, MA 02116					1010	2020		Sprint
Sheet2

 

[LostinVA]

That's what the formulas did, I thought...when the addresses match, the data was copied. Otherwise, nothing was done.
If you provide a bit more data and what you expect when there's a match, that would help.

Maybe you don't mean row-by-row, but I'm only guessing with only 1 line of data per sheet.

Is this what you mean?

Book1
	A	B	C	D	E	F	G	H
1	Address	Carrier	Service	MRC	NRC	C2F Supplier	MRC	NRC
2	100 HUNTINGTON AVE, BOSTON, MA 02116	Granite Grid	Grid FE - 10Mbps	360	1250	Sprint	1010	2020
3	1 Main Street	Whatever	Grid AA	100	200	AT&T	999	888
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=VLOOKUP($A2,Sheet2!$A$2:$I$100,9,FALSE)
G2:G3	G2	=VLOOKUP($A2,Sheet2!$A$2:$I$100,6,FALSE)
H2:H3	H2	=VLOOKUP($A2,Sheet2!$A$2:$I$100,7,FALSE)

Book1
	A	B	C	D	E	F	G	H	I
1	Address	City	State	Zipcode	Country	MRC	NRC	Term	Supplier
2	333 Canal St	New Orleans	LA	70130	USA	565	500	12	Cox Communications
3	1 Main Street					999	888		AT&T
4	100 HUNTINGTON AVE, BOSTON, MA 02116					1010	2020		Sprint
Sheet2

Yes, I am a complete dope. Simple, straight forward vlookups. I am SO sorry for wasting your time. Thank you for your help, really appreciate it!

 

[kweaver]

Never a waste of time...happy to have helped.
In the future, based on this experience, I hope you see that more info the better because otherwise anyone trying to find a solution for you is only taking pot-shots at it.

 

[LostinVA]

Never a waste of time...happy to have helped.
In the future, based on this experience, I hope you see that more info the better because otherwise anyone trying to find a solution for you is only taking pot-shots at it.

Absolutely agree! I will definitely provide more information next time. Love this forum, thank you!