How can I pull certain row info based on column info
 

I would like to create a worksheet that looks up data in column 1 and then pulls specific cell data from that row.


This is not my spreadsheet and it's huge, over 150 columns.

Column 1 has a let's say a control number 1 thru 50,000.

Column 2 - 150 has Value1, value2, value3, value4, etc.

I would like to search for a control number like 3257 and have it automatically insert the data in column F, DD and Z from that row.

Then be able to change the control number at any time to get the new data from that row.

Is this possible? or is it confusing.

How can I pull certain row info based on column info
 

On Wednesday, April 8, 2015 at 10:49:03 AM UTC-5, Netti wrote:
I would like to create a worksheet that looks up data in column 1 and
then pulls specific cell data from that row.


This is not my spreadsheet and it's huge, over 150 columns.

Column 1 has a let's say a control number 1 thru 50,000.

Column 2 - 150 has Value1, value2, value3, value4, etc.

I would like to search for a control number like 3257 and have it
automatically insert the data in column F, DD and Z from that row.

Then be able to change the control number at any time to get the new
data from that row.

Is this possible? or is it confusing.




--
Netti

Not enough info. Better to send me a file with the logic fully explained and before/after sample dguillett @gmail.com