Question for Accountants!

[bencar]

Hi guys,

This is a question for all you accountants. I'd like to know what do you use vlookup on or other function specifically. And please provide examples... not with excel but in your words. For example, how would you use vlookup or sumif with the trial balalnce or general ledger?

 

[Joyner]

I have used lookup Functions a lot over the years and there are lots of examples, but on a trial balance or general ledger, not sure if I ever have for any reason. Regarding SUMIFS, I would never use that because I will always use a Pivot Table, and now for VLOOKUP, I will go to PowerPivot / Power Query first if that makes more sense.

Just my two cents.