|I currently have data in 4 different tabs within an excel spreadsheet. An info tab, paste product data tab, category data tab, and a feed tab. |
I am using the following VLOOKUP formula:
=VLOOKUP($'Paste Product Data'.C3;$'Category Data'.$A$2:$B$9682;2;0)
I would also like to include data from column C2 of the Category data sheet. For example, column B of the category data sheet says "Plush Toys." This is populating correctly in the Feed tab in column E. I would also like to pull data from Column C in the Catagory Data tab into Column E of the Feed tab.
Basically - Column B of the Category Data Tab shows "Plush Toys." Column C of the Category Data Tab shows "Classic." I would like Column E in the Feed tab to read "Plush Toys - Classic." How do I do this?