excel Formula

A

anju

where to serch for Formula tab to set up data table from criteria selection
(for V look up function)
 
F

Fred Smith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
Creating a Chart on form from selected data in query. 0
Use TODAY() function as the criteria in a SUMIF formula 1
Cells not updated automatically 3
Searching for a word and then copy the whole row 5
adding multiple values from matched search results 3

Top