Hi all,

Apologies I'm sure this is really simple but I'm on a deadline and this has been thrown at me!

I am looking to create an outcome in cell C1 dependent on the answer to a question in cell B1 and generated from a pre-populated list from column A on another tab in the same worksheet.

As an example.

Question in cell A1. If the answer to the question is "Yes" in B1 then it will populate "We would advise that you seek the advice of a GP" in C1 as linked to a generated list in A1 on the next tab.
Question in cell A1. If the answer to the question is "No" in B1 then it will populate "No further action required" in C1 as I'll ask it to link to the value A2 on the next tab.
Question in cell A1. If the answer to the question is "Don't know" then it will populate "Please see HR" in C1 as I'll ask it to link to the value of A3 on the next tab.

My limited skills tell me it's along the lines of (I don't know the exact terminology) that IF the value in B1 is "Yes" then display the information from A1 (on the other tab).

I really hope I've explained this properly.