Thread: excel Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default excel Formula

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.

"anju" wrote in message
...
where to serch for Formula tab to set up data table from criteria
selection
(for V look up function)