Andrea Johnson
asked on
SUMIFS WITH VLOOKUP
Hoping someone can help.. I want to put result in cell Q7
If cell I7 = "AUD" then I need to multiply value in cell L7 by the rate in row 2 where the number in row 1 corresponds with the number in cell G7 (so a lookup) - but if cell I7 contains "USD" then I just want to return the value as it is in cell L7. Then need to copy this formula down column Q. Pls see attached pic & excel sheet.
Can anyone help? Much appreciated..
C--Users-johnac9-Documents-Excel-Que.png
C--Users-johnac9-Documents-excel-qu.xlsx
If cell I7 = "AUD" then I need to multiply value in cell L7 by the rate in row 2 where the number in row 1 corresponds with the number in cell G7 (so a lookup) - but if cell I7 contains "USD" then I just want to return the value as it is in cell L7. Then need to copy this formula down column Q. Pls see attached pic & excel sheet.
Can anyone help? Much appreciated..
C--Users-johnac9-Documents-Excel-Que.png
C--Users-johnac9-Documents-excel-qu.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Asker acknowledged answer without following through with expected closure.
ASKER