Good news!!! We have upgraded the excel formula help page to a new, more easily accessible and better laid out page. Now the 50 formulas have been categorized in to 6 areas
- Mathematical Functions
- Text Functions
- Logical & Reference Functions
- Date & Time Functions
- Financial Functions
- Information Functions
Also, each formula has its own easy to remember url. For eg. you need help on countif formula, just type http://chandoo.org/excel-formulas/countif.html
This means, more of you can discover the formulas and help through search and sharing the links.
Remember, you can also buy an easy to read excel formula help e-book for just 5$.
Please spread the word about excel formula help page by stumbling it or tweeting about it or adding it to your delicious bookmarks. You will do me and this blog a very great favor by spreading the word.
6 Responses to “Using Lookup Formulas with Excel Tables [Video]”
H1 !
this is my very first comment.
Can you use same technique with Excel 2003 lists ?
thanks 😀
Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂
@Damian.. Welcome to chandoo.org. Thanks for the comments.
Yes, you can use the same with Excel 2003 lists too.
@Tom.. You have seen future and its awesome.. isnt it?
[…] Using Tables – Video 1, Video 2 […]
[…] Using Tables – Video 1, Video 2 […]
Hi, is there a vlookup formula for the second example (IDlist)? I used a similar formula to look up the ID for the person, but the reverse way (look up the person with the ID) comes up N/A.