where to serch for Formula tab to set up data table from criteria selection (for V look up function)
A anju Nov 19, 2008 #1 where to serch for Formula tab to set up data table from criteria selection (for V look up function)
F Fred Smith Nov 20, 2008 #2 There is no "Formula tab" required. Put the data table wherever you want. A common method is to put it on a separate sheet. You would reference this like: =vlookup(a1,sheet2!$A:$D,3,false) Regards, Fred.
There is no "Formula tab" required. Put the data table wherever you want. A common method is to put it on a separate sheet. You would reference this like: =vlookup(a1,sheet2!$A:$D,3,false) Regards, Fred.
