Friday, December 19, 2014

Creating a report in excel using data from two excel files.

12/19/2014..

 I got a request from client asking to design a report in excel using resource info sheet and bill rate report.

Final report should have resource id, name, loc, bill rate. Res id is common in two input sheets, i hope you got it, yes this could be done by vlookup.