Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I hope this makes sense - I have one workbook with many spreadsheets in that
workbook with Microsoft Excel. I want to be able to use this same workbook with Microsoft Works - Spreadsheet but when I copy and paste, the formulas I have to a Works spreadsheet the formulas aren't recognized. Is there a way to fix that or is it impossible?!?!?! P.S. I realize that with Works I can't have one workbook with many spreadsheets. Will it work if I want to connect many different spreadsheets? The formula is: =IF(ISERROR(VLOOKUP(B4,'Avon Products'!$A$2:$B$2439,2,FALSE)),"",VLOOKUP(B4,'Av on Products'!$A$2:$B$2439,2,FALSE)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with MS works Spreadsheet | Excel Worksheet Functions | |||
Opening Office Excel file in Works suite | Excel Discussion (Misc queries) | |||
how can i open an excel file using microsoft works? or can I? | Excel Discussion (Misc queries) | |||
How do I import Microsoft Word files into Microsoft Excel? | New Users to Excel | |||
how do I make excel 2003 my default spreadsheet over ms works spr. | Setting up and Configuration of Excel |