Function for Multiple results from a look up in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Isabelle - 14 Apr 2004 23:26 GMT

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

Reply to this Message

Frank Kabel - 15 Apr 2004 08:53 GMT

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

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I am working on a table with mutliple datas (about 40 columns and 2000
> rows), with text and numbers.
[quoted text clipped - 9 lines]
> Excel Templates, Training, Add-ins & Business Software Galore!
> Free Excel Forum http://www.ozgrid.com/forum ***

Reply to this Message