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

Convert all the dates in the form of names. Then convert all the values in dollars in pounds. If the value in pound is greater than 100 then delete that row .If the pound value is less than 20 then also delete it . Make a new sheet with the dates and day together if the day is monday make that row blue. For tuesday-Green For wednesday-Red For Thursday-White For Friday-Black For saturday-Pink Transpose all the data and add it into new sheet . Make a new sheet with all the reference values and if they are same ,delete that row. Make a hlookup and vlookup table for type and day of sale. Segregate the month field from data .

I need help editing the following formula. =IF(VLOOKUP(I16,Transactions!$D:$J,1,0)=I16,"FALSE","TRUE") The formula should compare Column I on the "Payments" sheet and Column D on the "Transactions" sheet and return the value from Column I if the value is NOT included on the Transactions sheet.

I have a spreadsheet with over 250,000 records about heating and insulation, The headings are - Measure Category, Measure Type, Property Type, Pre Main Heating Source, Post Main Heating Source, Name Of Uplift, Uplift, Average POPT Factor, Cost Score and Annual Saving. I want to use a formula where you type criteria in measure type to average popt factor and it comes up with the cost score and price. I have tried if statements and Vlookup etc but have gotten nowhere, Please Help.

Hello, I'm new to userforms and vlookup in VBA please bare with me. . I need to update qty values with Vlookup Function in VBA in sheet11. It has 3 columns: Part Number, Qty Received, and Qty Used. So far, I can get the selected part number in the textbox, I can unload the userform, I can't add or change the qty on either qty received or qty used. I did make an update button. I was getting all kinds of error messages on my formulas. Now, I don't get any error messages but the update button doesn't do anything. I can send you a picture of what I have if it's possible. Any help is greatly appreciated. Thanks

I want a VLookup formula that delivers "Duplicate or No" in column C if Column B is also in A

Hi! I am currently working with a project where I have to find the BMI percentile of 2000 individuals age group based on gender. I have two tabs with an array that supplies the ranges of BMI percentiles for age and BMI but they are grouped by gender. I have ages in months and BMI in a third tab. I need a equation for a third column to sort if an individual is male or female, then I need it to reference the age and BMI in the other tabs to generate the listed percentile for the group. I have so far tried a Vlookup and match index but I am still having errors. Any help is greatly appreciated!

I am looking for vlookup solution that no longer shows results if there is data in another cell (where we would enter something showing it complete)

very complex vlookup, if error lookup stuff please help! Already had some expert help, thanks

Create a formula to determine each student’s total stipend once the loyalty bonus percentage is applied. Use the reference table with the defined name of LoyaltyBonus, which shows the percentage increase. You must an IF function with VLOOKUP function in your formula, and you must use the defined name of the reference table. (Hint: note that there is no loyalty bonus for the first year.)

7. There is a scholarship available to female band members who maintain a sufficient GPA. Add a column to the table named Womens Scholarship. Create a formula to determine the scholarship that female band members will receive based on their GPA. Use the reference table with the defined name of WomensScholarship, which shows the scholarship amount based on GPA. You must use excel IF function and excel VLOOKUP function and you must use the defined name of the reference table. (Hint: this table shows GPA threshold cut-off values.)