Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do I use Vlookup?
i have a data table with over 190 columns and over 500 rows.
In another spreadsheet, I need to write a formula that will extract data from the data table based on a criteria which i will set. So for example, I only want to extract the row from the data table that has the name Residential. How do I do this? Example: Data table A B C D XYZ Residential 111 Street 10,000 ABC Office 99th street 20,000 GHI Mall 10th street 40,000 JJJ Residential 14th street 10,000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and its properties | Excel Worksheet Functions | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |