Fill one cell depending on value of another

I'm trying to create a Risk Assessment sheet in Excel.

I have one drop-down with days at the moment and I want another cell to be populated depending on what day is selected.

I have managed to get this working for one day but not all days.

=IF(F16="Monday","Apple","")

How can I expand this formula to show the following:

F16 = Monday, G16 = Apple
F16 = Tuesday, G16 = Orange
F16 = Wednesday, G16 = Banana
F16 = Thursday, G16 = Pear

Solution 1:

Basically what you are looking for is called a LOOKUP function in excel.

Step-1: Make a list of X and Y (in your case DAYS and FRUITS) - let us say this range is A1 to B7

Step-2: Write the following formula in the cell where you want the fruit name to appear =VLOOKUP(A8,A1:B7,2,0) (assuming that A8 contains your DAY)

Solution 2:

If you don't want to add additional cells just like Prasanna suggested just add:

=IF(F16="Monday","Apple",IF(F16="Tuesday","Orange",IF(F16="Wednesday","Banana",IF(F16="Thursday","Pare",""))))

Solution 3:

Depending on your version of Excel, you may be able to use the IFS function. This essentially performs the job that the nested IF function would do.

In G18, try:

=IFS(F16=Monday,Apple,F16=Tuesday,Orange,F16=Wednesday,Banana,F16=Thursday,Pear)