| Why No Links? |
-
You can find anything you want using google.
-
Lots of other excel sites have really good links pages.
-
There are a number of excel blogs which may have an answer for you.
Ok. Just in case you’re really stuck here’s a link to the J-Walk and Associates links page.
Googling Tips
Here are my tips on google searching for excel stuff:
Webs sites before news groups:
If you can find your answer on a website it’s often likely to be easy to understand, thorough and wide reaching in its explanation. Newsgroups are for specific questions so sometimes it can be tricky to find the answers you want – especially if you don’t know what you’re looking for in the first place!
Ask the right question:
If you can’t find what you’re looking for try asking the question in a different way. Be as specific as you can, and broaden your search if you don’t get any results. If you get close to what you think might be an answer start to use words and phases that the sites you are getting hits from are using, - develop your question.
Make use of searching features:
Following on from the above, instead on typing Problems with Vlookup or Vlookup errors
typing
“Vlookup” + “#N/A”
is more specific (if the error you have is #N/A!)
The quote marks make google (or any other engine) look for that exact words, the + tells google to find a results with #N/A also in the text. There are lots more search operators you can use.
Using News Groups:
If you don’t understand what newsgroups are, or how they work don’t worry! Google has an excellent feature where you can search news groups from the web, you can also post questions. It’s really very easy.
When asking questions do the following:
- Only ask one question in one post!
- Give as much information as you can, but don’t be wordy.
- Give an example (inputs and outcomes you want).
- Explain any problems that you have – i.e the list must be in the same order then I have fished, as when it started.
- Say thank you!!!!
Here’s an example:
|
Topic: Vlookup returns #N/A Messages: I have a spread sheet with 2 different pages, Report and Data. On the sheet called report I have a vlookup, which is returning a #N/A, the formula in the cell is: =VLOOKUP(D11,Data!D5:E31,1) My lookup range is a list of numbers I copy and paste from a data base and is held on the sheet called data. I’m not sure why I am getting the #N/A error. I want to match any value on the Report sheet with data from the Data sheet, if there is no match, I would like "No match" to be displayed. Many thanks Ross. |
Blogs, or web logs, are a special type of website. They're special because they're updated regularly, normally each day or each few days, and you can leave comments about the topics discussed. The blogs listed here are excellent for getting excel help!
Unofficial Microsoft Office Stuff (excel section)
Google Adds ?