How to Use VLOOKUP to Define Multiple Columns

February 23, 2011 at 11:43:50
Specs: Linux i686
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?


See More: How to Use VLOOKUP to Define Multiple Columns

Report •

#1
February 26, 2011 at 16:41:44
Vlookup relies on unique identifiers. It is misunderstood often. You need to lookup a unique identifier and that column must be the first column in your lookup list.

So, try lookup versus Vlookup. Watch the true or false at the end of the statement. Most of the time you would use false. Google if you are not getting the results you need to further explain the true and false at the end of the statement.

I'm still learning everyday.


Report •
Related Solutions


Ask Question