Are you stuck on Excel or Google Sheets?

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

I have a main dataset of about 500,000 line items. I want to lookup the items from 3 different datasets. Each of these datasets has got about 200,000 line items. I want to use the if and vlookup function to return a " Yes" or "No" answer.

I have a sheet with lots of IFERROR and VLOOKUP formulas. If I want to add two VLOOKUP formulas together, how do I create an IFERROR if no value is returned?

I need to vlookup with 2 different criteria, so I will be doing: IF this name occurs on this date, then how many hours did they work?

I am not sure if my vlookup is working correctly. I have 30,000 ID to match but only 3,000 matched which makes me concern. I need to identify the duplicates and eliminate them.