Extracting data

A

Antonio

Hi, all

Need your help for the following:
Have a excel database with 75 columns and about 1750 rows.
How can I extract the contents of a full row, when a specific criteria
is met on column 1?

Any ideas?

Tks in advance
 
F

Frank Kabel

Hi
you could use multiple VLOOKUP statements. e.g. something like
=VLOOKUP(value,I1:X100,COLUMN(A:A),0)
and copy this to the right
 
Top