How can I take info from one tab and add it to another? For example, I have Tab 1 with column A—call it “cat breeds”—and I have Tab 2 with column A—call it “cat breeds”—as well. They need to match so if these two match I need Tab 2 column B with “cat names” to show in Tab 1 on the same row that matches the “cat breeds” in a new column.

How can I take information from one tab and add it to another? 

For example, I have Tab 1 with column A - call it cat breeds - and I have Tab 2 with column A - call it cat breeds as well. They need to match so if these two match I need Tab 2 column B with cat names to show in Tab 1 on the same row that matches the cat breeds in a new column.

How can I take info from one tab and add it to another. for example I have Tab 1 with column A call it cat breeds and I have tab two with Column A call it cat breeds as well they need to match so if these two match I need Tab 2 column B with Cat names to show in Tab A on the same row that matches the cat breeds in a new column.

How can I take info from one tab and add it to another? For example, I have Tab 1 with column A—call it “cat breeds”—and I have Tab 2 with column A—call it “cat breeds”—as well. They need to match so if these two match I need Tab 2 column B with “cat names” to show in Tab 1 on the same row that matches the “cat breeds” in a new column.