Have you ever needed the vlookup ability on a subtotal? Here's a rather quick way (once you get used to typing it out), to return a value from a subtotal sheet. There's one more step added to get rid of the #NA.
Check out the example.
http://www.mediafire.com/file/yj0vojvz5qu/VlookupSubtotal.xlsx
Tyler
No comments:
Post a Comment