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?
|