CODEWITHSUNDEEP
excelvbavlookup
LOZ
LOZ

Reputation: 1177

Matching two columns from two spreadsheets and grabbing data from one of the spreadsheets

I need to match values (texts) between two columns on two different spreadsheets.

To make it easy I brought them together into one sheet.

Currently I have Column A, B, C, D, E and F from the second (2nd) sheet pasted into the first (1st) sheet. After Column F, everything is related to the original (1st sheet).

I am trying to match data from Column A (2nd sheet data) to Column G (1st sheet data). If there is a match, I want to grab the entire row/columns related to Column G, in this case the information from the 1st Sheet. This is the formula I use and it finds the differences between the two columns, but I cannot figure out how to match it to Column G, and obtain the detailed row with it.

=IF(COUNTIF($A:$A, $G5)=0, "Doesn't Exist", "")

Just to note, the two columns being matched have similar data but are scattered.

Upvotes: 0

Views: 349

Answers (1)

scorpion
scorpion

Reputation: 75

It looks like you mean you want to join row from 2nd sheet to row first sheet. Right?
I dont't understand why you merge data to one sheet. Keep it seperate on two sheets.
If column G 1st sheet and column A 2nd sheet are the same then you can use this to match.
Place formula in column H 1st sheet. With this formula you wil fetch data from column B 2nd sheet to column H 1st sheet.
=index(sheet2!B1:B3;match(sheet1!G1;sheet2!A1:A3;0))

Repeat formula in next columns, I, J, K, L...etc

Upvotes: 1

Related Questions