Function for Multiple results from a look up in a table

  • Thread starter Thread starter Isabelle
  • Start date Start date
I

Isabelle

I am working on a table with mutliple datas (about 40 columns and 2000
rows), with text and numbers.
I am trying to set up a sort of cross reference.

I want to compare 2 parameters of a same row for a specific part with
all the other part on the table; and get as a result all the part with
the same value in the parameters(columns) (or range of value, +/- 5%)
How can I do that ?
Thank You

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Hi
not really sure what you're trying to achieve. Could you post some
example data (plain text - no attachment please) and describe your
expected result based on this example
 
Back
Top