Is it possible to create a look up list for a field, in which the list displayed will depend upon the contents of the previous cell? EG. I have an 'Area' field (the contents of which is selected from a drop down box). If Communication were selected from this list I need the drop down for the 'Skill' field to display 'Listening and asking questions', 'Explaining, coaching and informal teaching'. If a different option were selected for 'Area' a different list of options would be needed for the 'Skills' field.

PLEASE HELP! This is driving me crazy!

It seems to me that you need cascading combo boxes.
Please search the forum, there are plenty of posts and examples
on this topic.

I agree with trucktime. However, you must do this in a form, not at table level.