Forum Discussion
Combining VLOOKUP and IF to pull data from an entire row
Looking at what you are doing I wonder why you want to have 5 separate worksheets when everything you want is already on one. It would be simpler just to use filters on your "All Proposals" worksheet. By choosing the appropriate filters on the TypeofFunding and Funded columns you get a sheet with exactly what you want.
Hi John,
We previously made these separate sheets because we regularly report these lists of grants and their amounts, and it is more convenient to have them as separate sheets for this purpose.
We also have graphs that are linked to these sheets that show the total requested and total funded amounts. Even so, it might be less tedious to have a "Total" cell for each condition on the main spreadsheet and then link this entry to the graphs. If there is no direct reference formula for entire rows on separate sheets, it might be easier to do it this way.
Thank you
