Thank you for responding Joel, I had the same problem with my first offset
function in that i kept getting the #REF! error and i managed to work it out
but i can't seem to work out the #REF! error with your function. Can you
advise me where i may be going wrong?

Thanks
Lynda

"Joel" wrote:

Use Indirect

=Indirect(OFFSET(Lists!J1,'Dropdowns'!G35-1,0,1,1))



"Lynda" wrote:

I am sorry for posting this again but there must be someone out there among
you gurus, that can help me with a formula that will change numbers to text
PLEASE.
I have created a number of surveys or requests for information sheets in the
same format, that being dependant dropdown lists using the combo box from
forms toolbar so I really dont want to change my format.


Sheet 1 €“ Combo boxes (dropdowns) gets lists from sheet 2. I have my
combo boxes attached to cells in sheet 1.
Sheet 2 €“ has my lists for the dropdowns
Sheet 3 €“ I want the cells in sheet3 to pick up the data from cells attached
the dropdown cells in sheet 1. When the data sheet picks up the info from
the cell in sheet 1 it gives me a number and not the text in that cell.
I was given a formula =OFFSET(Lists!J1,'Dropdowns'!G35-1,0,1,1). I have
managed to get most of them working, the ones I am having trouble with now
are those that are attached to a dependant drop down list.

Sheet 1(dropdowns) Sheet 2(Lists) Sheet 3(Data)
D38 (got this one working) ColumnA G3
G38 (this one is dependent on D38) ColumnB H3
K38 (this one is dependent on G38) ColumnC I3

E44 (got this one working) ColumnO K3
H44 (this one is dependent on E44) ColumnP L3
I have tried experimenting with other formulas but I am just so hopeless.
I was going to give up but it is driving me insane, please, please, please
someone, anyone.
Thank you
Lynda