This is my first post on this messageboard, so I look forward to any help that I can get.
I read the posting guidelines, so I've got to say up front, I unfortunately don't know what version of Excel I'm using. Though I have some degree of skill with excel, I certainly don't know about a lot of it's ins and outs and capablilities, so perhaps there are some simple answers to my questions below that I simply am unaware of.
At any rate, here are my two questions explained as completely and clearly as I can:
1) I'm using a vlookup in one spreadsheet where I've got a large listing of trial balance account number. Then, in another spreadsheet, I'm copying and pasting trial balalnces with the TB account numbers and figures for each of those accounts. These account balances get pulled into the other spreadsheet via the vlookup, however, not all trial balances have all of the acct numbers, so in this instance, the other spreadsheet, when trying to do a vlookup for that account, obviously can't find it and inserts "#N/A" into the cell. This causes errors in other formula's that I have on that spreadsheet, so, I'm wondering how I can get the vlookup to insert a numeric zero into the cell rather than the "#N/A".
2) Here's the 2nd question....I'm trying to convert a word document which has different numeric figures in it into an excel document where it can pull these figures, so what I was thinking was copying and pasting each of these paragraphs of sentences into single excel cells. I'm wondering if there's a way that I can somehow have say "IF(then)" formulas within the body of this text, all of which will be in a single excel cell, where the "IF(then)" formula's pulls numbers from other spreadsheets within that workbook? If this is not possible, which I've thought it could be, is there any suggestions on alternate methods to get the same result without putting each word from these sentences and paragraphs into individual cells?
Lastly, I have a simple question about something that happens that's funky....I have all of my print area's clearly defined in various spreadsheets, but for whatever reason, the first time you go to print some of these sheets, the data on these spreadsheets is either elongated or compressed so that it's not printing it in a readable format. If you reprint it even one second later, it comes out fine, as was intended, so all it takes is hitting that print key a 2nd time, however, it's simply an annoyance and a waste of paper. Any ideas on why this occurs and what can be done to avoid it?
to whoever is able to give some advice and help on the above, I truly appreciate it in advance and thank you for welcoming me to this board.
thanks,
Terry
I read the posting guidelines, so I've got to say up front, I unfortunately don't know what version of Excel I'm using. Though I have some degree of skill with excel, I certainly don't know about a lot of it's ins and outs and capablilities, so perhaps there are some simple answers to my questions below that I simply am unaware of.
At any rate, here are my two questions explained as completely and clearly as I can:
1) I'm using a vlookup in one spreadsheet where I've got a large listing of trial balance account number. Then, in another spreadsheet, I'm copying and pasting trial balalnces with the TB account numbers and figures for each of those accounts. These account balances get pulled into the other spreadsheet via the vlookup, however, not all trial balances have all of the acct numbers, so in this instance, the other spreadsheet, when trying to do a vlookup for that account, obviously can't find it and inserts "#N/A" into the cell. This causes errors in other formula's that I have on that spreadsheet, so, I'm wondering how I can get the vlookup to insert a numeric zero into the cell rather than the "#N/A".
2) Here's the 2nd question....I'm trying to convert a word document which has different numeric figures in it into an excel document where it can pull these figures, so what I was thinking was copying and pasting each of these paragraphs of sentences into single excel cells. I'm wondering if there's a way that I can somehow have say "IF(then)" formulas within the body of this text, all of which will be in a single excel cell, where the "IF(then)" formula's pulls numbers from other spreadsheets within that workbook? If this is not possible, which I've thought it could be, is there any suggestions on alternate methods to get the same result without putting each word from these sentences and paragraphs into individual cells?
Lastly, I have a simple question about something that happens that's funky....I have all of my print area's clearly defined in various spreadsheets, but for whatever reason, the first time you go to print some of these sheets, the data on these spreadsheets is either elongated or compressed so that it's not printing it in a readable format. If you reprint it even one second later, it comes out fine, as was intended, so all it takes is hitting that print key a 2nd time, however, it's simply an annoyance and a waste of paper. Any ideas on why this occurs and what can be done to avoid it?
to whoever is able to give some advice and help on the above, I truly appreciate it in advance and thank you for welcoming me to this board.
thanks,
Terry