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.