Hi,
Is it possible to create an IF Formula that will auto populate a cell based on the information contained within another cell that has been populated via a drop down list? Attached is an example of what I need - On the worksheet 'Summary' column A is a drop down list, based on the information within it can column B auto populate? For instance is Scotland is selected in cell A2 is it possible for the name Mark Owen to appear in cell B2 and if South West is selected in cell A3 that the name Jon Jones appears in cell B3?
Cheers
Bookmarks