I want a table to compare between values that are extracted by formula from a different table, by name.
please see the attached file, containing explain of the contant and needs.
thank's,
Amit
Thanks a lot, that works great.
I did it with a differant formula, using Vlookup (see the attached file).
I appriciate your time and attention to this issue and I would like to ask you about the differance between the 2 options.
clearly both works. my question is whether one of the options is more efficient?
which is prefered for larger tables?
I don't think there is any difference between the two approaches ; if at all , the VLOOKUP approach should be faster , even for larger tables , as long as the size of the table does not extend to too many columns ; rows should not be a problem.
