Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP......I am going insane....
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
This is DRIVING ME INSANE! | Excel Worksheet Functions | |||
PivotCharts, PivotTables, I'm going insane | Charts and Charting in Excel | |||
I am going insane trying to work this out... | Excel Discussion (Misc queries) | |||
Workbook file size is insane, calcs take forever | Excel Discussion (Misc queries) |