| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL SPREADSHEET FORMAULS
I COPY AND PASTE A FORMULA THAT LOOKS LIKE THIS =VLOOKUP($C577,'RELAY
SPECS'!$A$2:$U$299,14) AND IT GIVES ME THE CORRECT ANSWER IF i CHANGE IT MAUALLY TO =VLOOKUP($C577,'RELAY SPECS'!$A$2:$U$299,15) IT JUST GIVES ME THE FORMULA, IF I CHANGE IT BACK MANUALLY TO 14 IT ALSO GIVES ME THE FORMULA??? I AM USING EXCEL 2003 WITH WINDOWS XP THANKS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL SPREADSHEET FORMAULS
(a) turn off caps lock (though it won't help with the answer!)
(b) format the cells as general before pasting - they will be text at the moment. LERY616 wrote: I COPY AND PASTE A FORMULA THAT LOOKS LIKE THIS =VLOOKUP($C577,'RELAY SPECS'!$A$2:$U$299,14) AND IT GIVES ME THE CORRECT ANSWER IF i CHANGE IT MAUALLY TO =VLOOKUP($C577,'RELAY SPECS'!$A$2:$U$299,15) IT JUST GIVES ME THE FORMULA, IF I CHANGE IT BACK MANUALLY TO 14 IT ALSO GIVES ME THE FORMULA??? I AM USING EXCEL 2003 WITH WINDOWS XP THANKS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Importing an Excel spreadsheet from the web. | Excel Discussion (Misc queries) | |||
| Delay to startup excel spreadsheet | Excel Worksheet Functions | |||
| copy and paste excel spreadsheet into autocad | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
