Lookup Function For Checking 2 Vectors

subair · May 13th 2007

Hi
I want show a value from a chart by setting 2 conditions , I tried up with LOOKUP function but I cannot set 2 conditions. Can you please help

WinteE · May 13th 2007

Re: Lookup Function For Checking 2 Vectors

Join the two condition items together in a hidden column. Now you can use this column for a VLOOKUP() function.

**pike** · May 13th 2007

Re: Lookup Function For Checking 2 Vectors

This example may help. It will depend on how you have the data setout
You can combine the lookup and indirect functions to sort throught the Matrix.
There are heaps of other examples if you use the site search or use the build in help
pike:sheep:

Lookup Function For Checking 2 Vectors

Participate now!

Share