I have 2 worksheets. The 1 I add column headings and fill a formula in the cell below. The one formula needs to do a Vlookup from a different sheet (Ranged for stores), but the column it needs to copy the value from (Grand Total) is not always in the same column.
Thus I use the below formula to search the heading and the do a Vlookup to find the data, but it's not working.
Please Login or Register to view this content.
Bookmarks