Using a range name in formula
 

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?

Using a range name in formula
 

Yes,

=HLOOKUP(A1,Myrange,2,0)

HTH

"ScottG" wrote:

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?