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