I am trying unsuccessfully to use Vlook up on a file formatted similarly to this attachment and only produce #NA results.
I would like to look up lets say, row 11, Gross Profit - Bananas Retail for each store front.
Ive arranged the formula area to have store front in columns, value to be looked up in rows, and am stuck.
any help would be greatly appreciated, thank you for your time.
Last edited by venti30; 09-21-2016 at 05:14 PM. Reason: Typo
Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Trevor, thank you very kindly for your help. That was very helpful and I appreciate your time!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks