I am trying to do a hlookup based on a validation list. i.e. I have 4
expense types on four different worksheets listing a name against an expense.
My front page is a list of staff against which I want to populate the expense
by depending what is dropped down in the validation list which will go away
and select the reference off the appropriate table. Can I use a range name in
combination with a hlookup?