Advanced excel formulas

Hi All,

I am new here and would like to learn more about excel. Currently I am working as an accounting consultant, excel is used day by day. So I thought to share my knowledge about excel and have written a small tutorial related to advanced vlookups. It would be great to add new content, solving problems with vlookups, advanced vlookups,... Maybe by this way I can learn more advanced excel skills and add quality content to my vlookup tutorial. If this works great I am willing to write more tutorials. I added my first tutorial on my website, you can find it here http://www.freenergyshop.com/advanced-excel-formulas. If there are any remarks leading to improvements, please do not hesitate.

Thx. for reading,

Regards,

Renato

Thx for sharing Masw723...
Finde here some more ideas from abousetta for advanced VLOOKUP function and use them if you like:

http://www.excelforum.com/excel-tips...d-vlookup.html

best learning is while helping others

I was just going to pass on the same link, zbor, but you beat me to it.

One thing that you have not covered, Renato, is IFERROR, which is only available in XL2007 and later - your approach to use ISNA and ISERROR is the method you would have to use for XL2003 and earlier versions.

Hope this helps.

Pete

These are great, I will add this info to my tutorial.

Originally Posted by zbor

Thx for sharing Masw723...
Finde here some more ideas from abousetta for advanced VLOOKUP function and use them if you like:

http://www.excelforum.com/excel-tips...d-vlookup.html

best learning is while helping others

Thx. I added this to my tutorial. This saves to copy paste the vlookup all the time, and it combines ISNA and ISERROR Nice!

Originally Posted by Pete_UK

I was just going to pass on the same link, zbor, but you beat me to it.

One thing that you have not covered, Renato, is IFERROR, which is only available in XL2007 and later - your approach to use ISNA and ISERROR is the method you would have to use for XL2003 and earlier versions.

Hope this helps.

Pete