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

Hi, I have a list of customer account names and dates of orders placed for them. Some accounts have ordered multiple times, so there are different dates for the same account name. I am looking to make a table using that information that has a list of the same customer accounts, BUT next to each customer account name is their most recent placed order date. I'm attempting to use Vlookup, but I am having no luck whatsoever. I would really appreciate if you could help me out with this.

I need to use a IF function with a IFERROR(VLOOKUP function across multiple workbooks.

I have two Excel Files, one file of customer orders placed and one file with customer orders invoiced. The key linking criteria is the Order# which is present in each file and I need to determine which orders have been invoiced (have an invoice number because they are completed). However, there can be more (multiple) Invoices for the same Order#. Thus, using vlookup only grabs one or the first occurrence. How do I get 2 formula columns to return proper results. One simple column that returns a Yes or No for IF an Invoice# is present for an Order# and a column next to that that returns the Invoice# when invoicing has occurred (even when the Invoice# is different for the same Order#).

Design a workbook named sales_LastNameFirstName to help you track your weekly sales commission. Your name should list in cell A1 in an enlarged font size with a different color than the default color merged and centered across all columns used. Display in a labeled cell your weekly base pay as a salesperson. Display in a labeled cell the amount of commission earned the previous week. Your company pays commission based upon the number of sales made in the week. The commission rate is then multiplied by the weekly base pay to compute commission amount. An English description is given below of commission rates. Use that data to create a lookup table placed on the workbook. Add a box border around the lookup table. Number of Sales Commission Rate 1-9 3.0% 10-19 3.5% 20 or more 3.8% Include column headings for date, number of sales, commission rate, commission amount, and total pay. Format the column headings row with some border in a different color than the default color and each entry boldfaced and center-aligned in its cell. Include five rows of data for the five business days Monday - Friday. For the first row, enter a particular Monday date and for remaining rows, add 1 to the previous date to compute the new date. Use the VLOOKUP function to compute the commission rate for each day based on the number of sales. Compute the commission amount from the commission rate and the base weekly pay. Compute the total pay as the sum of base pay and commission amount. Under the rows add a labeled cell and display the sum of commission amounts. Use the IF function that compares commission amount earned this week to the previous week's value and reports some congratulatory message if the current amount exceeds the previous amount, and some other message otherwise. Format the message in boldface in the same font color as your name. Use Currency format with two decimals on all money amounts. Use Percentage format with one decimal on all percentage values. Insert a small money-related image to the right side of the row data to fit the size of the five rows. Rename Sheet1 appropriately and delete unused sheets. Add a header of your name in the left side, sheet name in the middle, and current date on the right side. Your workbook must be unique and reflect your own data and design.

Hi. I am trying to write a formula in cell I5 that includes both the IF function and the VLOOKUP function. I need to work out the grade using the figure from the Rounded Column and the table to the right. when dragged down the column i need the formula to leave a blank for any student who is yet to complete their test.

need help on a vlookup forrmula. trying to look up text in a table and if not there then return "inactive, if there then return "active"

Hi hope someone can help I have an extensive price file spread sheet within which I have set up a visual basic formula so that if any changes occur a date & time stamp appears in a cell. I then also have a Vlookup in place so in another location is someone views a particular product the said date appears using the below formula which works fine unless a product with no amendments is selected its returning a default date 00/01/1900 00:00 where I would prefer a blank empty cell. I realise there must be an IF statement to solve this but failing horribly to get it to work. Any help in the correct formula would be greatly appreciated. =VLOOKUP(H4,$AO$1:$AP$99999,2,FALSE) 00/01/1900 00:00 many thanks in advance

I am looking for an Excel formula that will take information from more than one row (column name is 'Line Total') on one spreadsheet and post the total to one row (column name is 'Invoice Total before taxes) on a separate Excel spreadsheet. The common variable is our PO (purchase order number). I hope this is enough information for you (this looks as though this is a VLookup scenario if I'm not mistaken. Thank you!

I need excel formula. Col A "BAU" which has BND, C/M, RMC, TBM and Col B "Curr" which has CAD, USD. Need vlookup and count formula which will count CAD+C/M, CAD+TBM and if not both available then either of it

im stuck on a vlookup formula if i attach the spreadsheet can you help