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

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.

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?

I have list of tickets data and need to apply Vlookup and IF Statement to it

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

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 column formula for this?

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!

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?

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.

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

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.