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

Hello - Vlookup question: In my workbook, if data from Tab 'BYOD Groups' Column C matches data from Tab 'ETFs' Column F, I need to populate data from Tab 'ETFs' Column G into Tab 'BYOD Groups' Column B for those matching values . What kind of a formula can I use to do that?

I have, say, 10 columns of data, and I want to be able to find all the values in between two dates and graph it by whatever column I choose. I have been searching online for a couple days but I keep coming up with #VALUE or #REF. I can get VLOOKUP to find the values, and I can get it to find a piece of data for the start time and the finish time.. but anything in between will not come up.. so I can't even graph it! I am trying to create a dynamic chart that will change if I type a datetime into a box for start and finish.

Add a formula to cell G4 that creates a Report ID from the date and the ID number on the ListData worksheet of the person who made the report. The excel IF function TEXT will include a TEXT function and a nested IF function with a VLOOKUP function. The logical test will verify if cell G2 is greater than 0. The value if true will include the TEXT and VLOOKUP functions: TEXT(G2,"YYYYMMDD"),"")&" "&IF(G1>0,VLOOKUP(G1,ListData!B15:C19,2) The value if false will return blank.

Need help with some general if than and vlookup formulas

I am trying to write an IF formula that returns a vlookup result.

Is there any way to have a formula that fills in an entire row on a table based on the information given in the first cell of that row using another tab as the data base? We are creating our own invoices for a new venture, and have several hundred SKU items (with descriptions, commodity codes etc) that need to go onto the invoice. IF we put all the information on a second tab/sheet, can we pull this through to the first sheet, possibly with a dropdown menu in the first column to select the appropriate SKU. I had initially thought of a VLOOKUP but don't think this will pull through all the information needed

Hi, Im a printing company that I Have a Job Cost model that is uses a VLookup Table to add which printer, and substrate and time to create a particular Product. I can enter a number in qty and once the the total is calculated , It gives me our cost as well as different margins for that particular printed product. My issue is , Id like to be able to create a table of different qtys that will propagate once I Fill in the Job cost model and it will show me different qty breaks without me having to fill in a different qty each time. I can send you what I have so far and see if you can help me with this.

Vlookup formula not working when combining with IF. If formula alone is not sufficient.

I am trying to provide a location and a total in that location based on a part number. I am trying to use Vlookup to return each location and it's total based on that part number. In some cases there may be up to 5 locations, each with it's own total. If I can at least get all the locations to show, I can pull the total myself. At most I can get 1 location, and it's always the highest on in the list. The LOC tab has the part number, location, and total. I want the location and total to show in the J to S range in the BOM tab.

Hi: I need help with VLOOKUP and different Excel Sheets. I can send you the instructions if I can to help me. Thanks. I have a PDF I tried to send