Thread: Index Match Vlookup Automatic

Hello,

please see attachment.

At work, I pull a raw data report, tab "Rev by Project"

so basically when i pull the report, i would like to copy and paste it to tab "Rev by Project"

and when i paste it, i would like to have

"transfer" tab automatically updated, column F should match perfectly with column E

I would like the cumulative last row for project "early"

please help, this would make my life so much easier.

Gross Revenue- =hlookup("GR",j4:N173,169,0)
Service Revenue- =hlookup("SR",j4:N173,169,0)

This should work and for YTD change the range

sorry, doesnt work at all, the rev by project tab isnt a "static" spreadsheet, more and more projects could come up and you would throw the range off.

and formula seem to be wrong, need more help please

bump for more answers

Back to top