Quick Excel Help
Get FREE step-by-step guidance on your question from our Excel Experts.
Quick Excel Help
Are you stuck on Excel or Google Sheets?
Check out some problems solved by our top Experts or click
to post your own problem for free!
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
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.
Solved by O. Q. in 40 mins
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?
Solved by D. S. in 18 mins
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?
Solved by T. S. in 60 mins
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.
Solved by V. E. in 60 mins
Click here to get your free Excelchat help session
Trusted by people who work at
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
Try for free