November 2008 has been the best month since I started this blog and thanks to all the readers and commenters for your tremendous support.
We had 33 posts and 331 comments (highest ever). We also had 150,000 page views, 50% more than last month and highest ever. Our RSS subscriber base is now at 1750 and growing everyday. This is a great feeling and I couldn’t have done any of this without your constant support and motivation. I am thankful to each and everyone of you for helping me learn and share whatever I can.
Here is a list of best posts in November:
- Select & Show One Chart from Many (38 comments)
- Excel Formula Helper
- Say thanks with an excel tip (22 comments)
- How to say same thing in 14 different ways? (6 comments)
- vlookup(), match() and offset() – explained in plain english [spreadcheats] (11 comments)
- Advanced Data Validation Techniques in Excel [spreadcheats] (8 comments)
- Ads that are also Infographics – 10 Dazzling Examples (1 comment)
- Separating digits from a number [excel formulas] (11 comments)
Support PHD:
If you enjoy the content featured here Share it with a friend or Bookmark this on Delicious or Stumble it!. It will make my day 🙂
You can keep up to date with PHD by subscribing to our RSS Feed or E-mail News Letter
Suggest:
Feel free to drop your suggestions, comments thru contact form in the About PHD page or email at chandoo.d at gmail.com. I *love* hearing from you 🙂
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.