• AVERAGE
  • AVERAGEIF
  • CELL REFERENCE
  • COUNT
  • COUNTA
  • COUNTIF
  • SUM
  • SUMIF
  • VLOOKUP
Get FREE step-by-step guidance on your question from our Excel Experts.
Quick Excel Help
  • AVERAGE
  • AVERAGEIF
  • CELL REFERENCE
  • COUNT
  • COUNTA
  • COUNTIF
  • SUM
  • SUMIF
  • VLOOKUP

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!

  • All solutions
  • VLOOKUP
  • How to Use
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

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, see here: Cookie Policy
  • Home
  • About
  • Excel Tutorial
  • Excelchat
  • Contact
  • Excel Problems
  • Experts
© 2025 Got It, Inc. All rights reserved.
Got it! Your question will be answered by an Excelchat Expert. Hang tight for 30 secs while we redirect you.

Save time by asking instead! Most questions solved and answered in 10 minutes.

Post your problem and you’ll get expert help in seconds.
Your message must be at least 40 characters
Free trial ends in 00 days 12 hours