Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel Formula
where to serch for Formula tab to set up data table from criteria selection
(for V look up function) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions |