Are you stuck on Excel or Google Sheets?

I need help with a vlookup for multiple duplicate references

I need Vlookup help across 2 workbooks into one other main workbook and can't figure out what i'm doing wrong!

Need help with Multiple Vlookup Function. Please only Expert Require.

I need help on vlookup. CAn you help me wiht that?

HOW TO USE VLOOKUP FOR ENTIRE SHEETWORK AND MULTIPLE TABS?

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.

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.

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

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

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