yogi_Extract For Specified Tab Name 'Total Hours' In Column F For Bottom Most 'Total' Entry In Column E

                                          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...

Hello

Here is the link to my test sheet:

https://docs.google.com/spreadsheet/ccc?key=0AtyokP6_wdZRdDEteHRkZm5OalB4SlFfcU5NUEI4SFE&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

-----------------------------------------------------------------------------------------------------------------------------