Hi,
Is it possible to use an IF Formula to pull through data based on a drop down list? Attached is an example document, what I need to know is, is it possible that if I select Scotland (worksheet 'Summary') in cell A2 that the name Mark Owen is auto populated in cell B2 and if I select South West in cell A3 that the name Jon Jones is auto populated in cell B3 etc etc?
cheers
Bookmarks