Resolved: i need help with question 4,5 from practice exam 3
I tried but solutions are very confusing
Thanks for reaching out! Happy to shed some light:
Question 4 - When you use VLOOKUP, you need to have a lookup value that is the leftmost column of the source table by definition. VLOOKUP cannot work when you want to lookup to the right. So, to solve this issue, you can cut the column with lookup values and paste it to the left so that it becomes the first one in the table.
Question 5 - This is a calculation. You need to delete the rows which say 'Total' and then use SUMIF as indicated in the answers to populate the 'Amount' column - it is your Sum_range.
Hope this helps!