Get instant live Excel expert help and learn how to use an IF function with a VLOOKUP

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have an IF statement that works. Its pretty complicated with VLOOKUP. But i need to make this an OR statement and i keep getting errors and can't figure out the formula.
Solved by F. S. in 17 mins
Hello, I have a list of value from highest to lowest with different names next to the values. When i do a vlookup of duplicate values i get the same name. Is it possible to lookup duplicate values and if a name already exists in the worksheet it goes to the next name in the report?
Solved by X. C. in 28 mins
I have list of tickets data and need to apply Vlookup and IF Statement to it
Solved by M. L. in 18 mins
using vlookup, look at the values in column C and Column K and if a match is found, pull match adjacent info from Column J and place the value in column D
Solved by E. E. in 19 mins
Excel question = If data in sheet 1, column A matches data in sheet 2, column A, then I need it to pull data from sheet 2 column B and place it into sheet 1 column c. what is the vlookup formula for this?
Solved by B. J. in 17 mins
Hi, I am looking for quick coaching on what I believe is the SUMPRODUCT formula, for doing a lookup that involves greater than or less than values in a target cell, to then return a specific value in a different cell. For example. I am measuring the value in B2, and depending if it is less than, equal to, or greater than a value in cell in c2, return the corresponding value from a table L4:N9. Kind of like a vlookup but different. Can you help with this? Should be quick and I am looking for assistance asap. Thank you!
Solved by M. J. in 11 mins
I am trying to fill small tables from a master data table, I am trying to use the vlookup but it doesn't seem to work as well for this as I thought it would. Could you take a look at this file and see if you have any suggestions?
Solved by Z. W. in 12 mins
Trying to set up a selection process for products. Each product has certain accessories and the choice of accessory can limit what other accessories can go with that configuration. I am trying to use INDIRECT, VLOOKUP combinations, but if there is a better way, I would like to know.
Solved by Z. Y. in 20 mins
Hi, I have a spreadsheet with a Summary tab, tabs for Jan-Dec, then a customer information tab. On the monthly tab is a list of every invoice for the month with a VLOOKUP to add the account managers name in once the customer name is typed. I want to make a formula on the summary page for the sum of the monthly sales for each account manager but it keeps coming up with errors. I'm not sure if this is because I'm putting if the cell with the VLOOKUP already in = the account handlers name and it's not picking it up because it doesn't have their name it has the formula? Sorry, I'm not that clued up on Excel - this is probably (hopefully) a quick, easy formula! Thanks
Solved by C. S. in 20 mins
i am having a couple little problems. I first need the date in cell b3 to stay at the date i started filling the information on the form. I also need the cell b23 to only do the VLOOKUP if cell b12 has data entered into it. my VLOOKUP formula works perfect and i have tried multiple different ways to only have it populate, with out any luck. I know i am missing something simple. please help.
Solved by K. J. in 29 mins