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

I need a formula to put in the column B in the COST SUB TAB, calculating excel table subtotal per resource from Column B in the Cost Plan tab (the result needed is similar to a Pivot TableNot with Resources in the Row and the Sum ofForecastedUnits in the values, however i would like a formula instead the pivot table for a similar result). Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.

I need a formula in the 2nd tab, to calculate the subtotal per resource from the 1st tab. Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.

I’m trying to do a Vlookup formula to have column ‘Q’ – INITIAL Risk Level populate data I put into column “P” – Occurrence (Failure/Cause). So, Column P should pull in numbers 1-5 from the “Risk Tables” sheet, then, once I enter in 1, 2, 3, 4, or 5, the risk level should populate in column ‘Q’, with the appropriate color “yellow or red”. Similar to what’s happening in column ‘V’ and ‘X’. Please see if you can assist in this formula headache.

I'm trying to conduct a vlookup on a field (a SKU number for a product in this case) and then look through multiple (consistently formatted sheets) for that same field (i.e., the SKU number) and the most recent price it sold for. I believe this means a vlookup with an indirect formula). However, if I would like for the formula to prioritize the order in which it looks for a SKU and price-match across the "invoice" sheets, is there a way to do this?

I need help in IF formula as well as Vlookup for which I am trying to figure out the solution but not getting through.

IF(ISNA(VLOOKUP($A4,'OP2 IR AMZ-Listings Tracker SKU'!$A$3:$B$500,2, 2,3,FALSE)),"SKU Missing",VLOOKUP($A4,'OP2 IR AMZ-Listings Tracker SKU'!$A$3:$B$500,2, 6,FALSE)) i can not share the excel sheet....... ..

how to use the vlookup function in excel? Ive made a list with data in one spreadsheet. With this data i have created a False and True list based on an IF function. I have furthermore created a counting system that counts 1,2,3...so on every time there is a TRUE. The problem now is that i want to transfer a line of data every time a number is counted, meaning that the line that is marked as TRUE needs to be transferred to the next page. Through googling i found that VLOOKUP might be useful, but i cant figure out how to use it exactly.. Can you help?

I am trying to get a formula to work on my excel sheet so that my customers can select their custom width and height for the painting they want to purchase. I have previously had help with a Vlookup function. Now I'm trying to multiply the total sum of the equation (width + height x base $) to arrive at the total price, after apply a discount of 56% and receive the total sum the customer would need to pay. Marked in red on the second table are the variables hights I tried to calculate. It would be helpful to know if I can have it all in one equation, I have tried to do it but to no avail.

I need to lookup a value from one column of a table, and return a number from that value's row in a different column. I know this is possible with google sheets hlookup, but the value I am looking up in the table has multiple entries. I want to add up all the numbers from each entry of the value. If that doesn't make sense, look at the google sheet I uploaded - I want to return every number for Russia, and add them up.

I need to correct a complex formula, I am getting an error. It includes a vlookup, if, and iferror