Google Spreadsheet Post #1471
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-03-2014
question by Jason Latsky (http://productforums.google.com/forum/?zx=lulvo3ls3zww#!mydiscussions/docs/nVEGG2ZK79g)
Vlookup on multiple sheets for total hours. Not working...
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-03-2014
question by Jason Latsky (http://productforums.google.com/forum/?zx=lulvo3ls3zww#!mydiscussions/docs/nVEGG2ZK79g)
Vlookup on multiple sheets for total hours. Not working...
Hello
Here is the link to my test sheet:
https://docs.google.com/ spreadsheet/ccc?key=0AtyokP6_ wdZRdDEteHRkZm5OalB4SlFfcU5NUE I4SFE&usp=sharing
I have the master tab set up so that our Administrative Coordinator can simply enter the name of the volunteer (whom I have renamed to Jane and Jon for now) and VLOOKUP will search that tab for the LAST entry of total hours.
I have a formula set up so far: =vlookup("Total", INDIRECT("'"&A4&"'!F:G"),2) where A4 contains the tab name (Jane or Jon)
Right now, it is returning #N/A, saying that "Total cannot be found". Total is there many times... I tried wildcards to no avail.
The issue is volunteers can enter either "Total" or Total:" into column E of the spreadsheet. Is this a problem?
Any help will be appreciated
-----------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment