hello
i m using Vlookup formula in this way :
in above formula 13.4.14 is sheet name,,,,,,,,,and i give a name to sheets with date......e.g 13.4.14, 14.4.14, 15.4.14=IFERROR(VLOOKUP(B4,'Z:\42766\Jan 2 Dec 2014\Tally.ERP9\[GrpSum.xls]13.4.14'!A$1:B$65536,2,0),0)
i want if A1.value=14.4.14 then sheet name should be 14.4.14
i don't want to change sheet name evrytime=IFERROR(VLOOKUP(B4,'Z:\42766\Jan 2 Dec 2014\Tally.ERP9\[GrpSum.xls]14.4.14'!A$1:B$65536,2,0),0)
plz help
thanx
Bookmarks