ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel Formula (https://www.excelbanter.com/excel-worksheet-functions/211001-excel-formula.html)

anju

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

Fred Smith[_4_]

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)




All times are GMT +1. The time now is 01:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com