Re: Find value in table based on two inputs

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "AMDRIT" <amdrit@xxxxxxxxxxx>
Date: Fri, 30 Dec 2005 10:45:17 -0600

Thanks for the quick responses gang. I really appreciate it. Sometimes I
can't see the forest for the trees.

"AMDRIT" <amdrit@xxxxxxxxxxx> wrote in message
news:e02CtcVDGHA.1180@xxxxxxxxxxxxxxxxxxxxxxx
> Given
>
> A1: Name B1: Dept C1: Age
> A2: Henry B2: 501 C2: 28
> A3: Stan B3: 201 C3: 19
> A4: Mary B4: 101 C4: 22
> A5: Larry B5: 301 C5: 29
>
>
> how would write a formula to find the age of 'Mary' in dept '101'?
>
> vlookup doesn't seem to support multiple compares.
>
>
> Thanks
>
>

.

References:
- Find value in table based on two inputs
  - From: AMDRIT

Prev by Date: Re: Turn off Zero values at the end of the chart
Next by Date: How to output an array in Excel with a user-defined function?
Previous by thread: Re: Find value in table based on two inputs
Next by thread: How to output an array in Excel with a user-defined function?
Index(es):
- Date
- Thread

Relevant Pages

Re: My PC just broke down.... :(
... Leave it to Steve to miss the forest for the trees. ... Prev by Date: ...
(comp.sys.mac.advocacy)
The forest from the trees! What was the task for Draco Malfoy?
... missed the forest from the trees. ... What was the task that Voldemort ... Prev by Date: ...
(alt.fan.harry-potter)
Re: Cold Fusion - Stings Lyrics Have Visionary Content (Think About It)
... forest for the trees. ... Prev by Date: ...
(sci.physics.fusion)
Re: Is there such a thing as an invalid thread id?
... I was in a "couldn't see the forest for the trees" mode. ... Thank you for the brain jog. ... Prev by Date: ...
(comp.os.linux.development.apps)
Re: Invalid use of NULL
... missed the trees through the forest! ... Darryl Kerkeslager ... Prev by Date: ...
(comp.databases.ms-access)