hi all,
kindly anybody tell me short cut to find out desired output if possible.
i have a record on station wise separate sheet. 50 sheets station wise.
i apply:
=VLOOKUP(F2,A2:D7,3,0)+VLOOKUP(F2,Sheet2!A2:D7,3,0)+++++
this is too lengthy.
is there any short cut to find Vlookup countif, SUMIF...