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!

I need help with a vlookup for multiple duplicate references
Solved by M. D. in 16 mins
I need Vlookup help across 2 workbooks into one other main workbook and can't figure out what i'm doing wrong!
Solved by G. E. in 19 mins
Need help with Multiple Vlookup Function. Please only Expert Require.
Solved by Z. J. in 40 mins
I need help on vlookup. CAn you help me wiht that?
Solved by V. H. in 20 mins
HOW TO USE VLOOKUP FOR ENTIRE SHEETWORK AND MULTIPLE TABS?
Solved by T. Y. in 40 mins
If a cell in another sheet is populated I need a vlookup done. If the cell is not populated I need the cell to return blank.
Solved by T. D. in 60 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
Hi, my VLOOKUP isn't working. No matter what I do it is returning the same result regardless of the sku it is searching for - even if I copy and paste the sky into the sheet the exact same way it is typed in the sheet its searching
Solved by X. H. in 20 mins
I'm trying to take a column with values and search a second sheet to identify if that value in the original column is present in the second column. I tried vlookup but it wants to change every column cell value dynamically instead of leaving the search range alone while dynamically adjusting the column number being searched. If I could just get it to say Yes or no that the value being searched is present in the second sheet, that would be enough
Solved by V. J. in 45 mins
Hi , I have all my active jobs on one sheet and I need to be able to have another sheet that links to the first with all the active jobs, then another sheet but with the inactive jobs. I'm not sure if its best to do this through filtering or Vlookup, i have no clue
Solved by K. F. in 40 mins
1 2 4 5 6