Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

HOW TO USE VLOOKUP FOR ENTIRE SHEETWORK AND MULTIPLE TABS?

Solved by T. Y. in 40 mins

I have 2 columns of data. Column A with a list of items (say computer SN) and Column B with a list of Sub items (accessories). An Item (column A) can have multiple sub items (column B) and vice versa. ColumnA ColumnB Item1 SubItem1 Item2 Subitem3 Item1 Subitem3 Item3 Subitem1 There are about 250 entries. I want to create a table with unique entries. SubItem1 SubItem2 Subitem3 Item1 YES No Yes Item2 No Yes Yes Item3 Yes Yes No Not sure how to use vlookup or Index/Match.

Solved by C. C. in 37 mins