Question

Click cell C9 and insert a VLOOKUP function that looks up the code in cell B9, compares it to the codes and types of art in the range B2:C6, and returns the type of art. Copy the function in cell C9 to the range C9:C54. Hide column B that contains the codes.

Click cell K9 and insert an IF function that determines if the Issue Price is equal to the Current Value. If the values are the same, display Same as Issue (using the cell reference K2); otherwise, display Increased in Value (using the cell reference K3). Copy the function from cell K9 to the range K10:K54.

Answer 1

Solution

Step 1

Go to cell C9

Step 2

Enter the following formula

=VLOOKUP(B9,$B$2:$C$6,2,FALSE)

Step 3

Enter

Step 4

Now copy the formula C9:C54

--

Step 5

Hide the column B

Right click on B

and select "Hide"

---

Next question

Step 1

Go to cell K9

enter the following formula

=IF(F9=I9,$K$2,$K$3)

enter

now copy the formula to K10:K54

--

--

all the best