If value in data range (multiple columns) return row

F

flickflick

I'm sure this must be the most basic question - but I don't quit
understand how to achieve this. Most of the functions I've read abou
online only look for data in one particular column - I'll need to loo
for values greater than or equal to "#" in multiple columns and as
that it returns the row with this value in, for instance, anothe
spreadsheet.

I have used conditional formatting to highlight such cells already so
imagine it can be done very easily - I just haven't found a way yet an
would really appreciate any help :)

Thanks
 
Top