=VLOOKUP(C4,'Named Fields'!AH3:AM116,6,FALSE)

Hi, and thanks in advance for your help.
I have the above formula set in a workbook.
I have sheet 1 with my main information.
I have sheet 2 with all my directives.

So, I have set up as follows:

sheet 1 contains:
cell c3= client
cell c4= project
The vlookup I have entered in cell c5 is to return a job number based on the
project in cell c4 which is listed on sheet2.
Problem is, I have multiple projects named the same. They're under different
clients.
I found a post that said I could use:

=vlookup(C3&C4,'Named Fields'!AH3:AM116,6,FALSE)

But that didn't work.

Is there any way to have vlookup find what's in cell C3, then proceed to
cell C4 to returns the results in the 6th column?

Thanks,

Debbie

Hi Debbie,

if on the column h you have figures, try to use sumproduct as

sumproduct(--(c7:c20="client")*(d7:d20="project"),(h7:h20))

hope this helps
regards from Brazil
Marcelo

"Debbie" escreveu:

=VLOOKUP(C4,'Named Fields'!AH3:AM116,6,FALSE)

Hi, and thanks in advance for your help.
I have the above formula set in a workbook.
I have sheet 1 with my main information.
I have sheet 2 with all my directives.

So, I have set up as follows:

sheet 1 contains:
cell c3= client
cell c4= project
The vlookup I have entered in cell c5 is to return a job number based on the
project in cell c4 which is listed on sheet2.
Problem is, I have multiple projects named the same. They're under different
clients.
I found a post that said I could use:

=vlookup(C3&C4,'Named Fields'!AH3:AM116,6,FALSE)

But that didn't work.

Is there any way to have vlookup find what's in cell C3, then proceed to
cell C4 to returns the results in the 6th column?

Thanks,

Debbie

Nel post
*Marcelo* ha scritto:

Hi Debbie,

if on the column h you have figures, try to use sumproduct as

sumproduct(--(c7:c20="client")*(d7:d20="project"),(h7:h20))

Hi Marcelo,

In this case you don't need "--". You can use sumproduct function in may
ways:

sumproduct(--(c7:c20="client"),--(d7:d20="project"),(h7:h20))

or

sumproduct((c7:c20="client")*(d7:d20="project"),(h 7:h20))

or also

sumproduct((c7:c20="client")*(d7:d20="project")*(h 7:h20))

But last one could produce errors if (h7:h20) contain a single text entry.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Marcelo and Franz,

Thanks but these didn't help.
Any other suggestions?



"Franz Verga" wrote:

Nel post
*Marcelo* ha scritto:

Hi Debbie,

if on the column h you have figures, try to use sumproduct as

sumproduct(--(c7:c20="client")*(d7:d20="project"),(h7:h20))

Hi Marcelo,

In this case you don't need "--". You can use sumproduct function in may
ways:

sumproduct(--(c7:c20="client"),--(d7:d20="project"),(h7:h20))

or

sumproduct((c7:c20="client")*(d7:d20="project"),(h 7:h20))

or also

sumproduct((c7:c20="client")*(d7:d20="project")*(h 7:h20))

But last one could produce errors if (h7:h20) contain a single text entry.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Nel post
*Debbie* ha scritto:


"Franz Verga" wrote:

Nel post
*Marcelo* ha scritto:

Hi Debbie,

if on the column h you have figures, try to use sumproduct as

sumproduct(--(c7:c20="client")*(d7:d20="project"),(h7:h20))

Hi Marcelo,

In this case you don't need "--". You can use sumproduct function in
may ways:

sumproduct(--(c7:c20="client"),--(d7:d20="project"),(h7:h20))

or

sumproduct((c7:c20="client")*(d7:d20="project"),(h 7:h20))

or also

sumproduct((c7:c20="client")*(d7:d20="project")*(h 7:h20))

But last one could produce errors if (h7:h20) contain a single text
entry.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Marcelo and Franz,

Thanks but these didn't help.
Any other suggestions?


Why didn't help? What is the result?


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

I got #Value when I used that code.


"Franz Verga" wrote:

Nel post
*Debbie* ha scritto:


"Franz Verga" wrote:

Nel post
*Marcelo* ha scritto:

Hi Debbie,

if on the column h you have figures, try to use sumproduct as

sumproduct(--(c7:c20="client")*(d7:d20="project"),(h7:h20))

Hi Marcelo,

In this case you don't need "--". You can use sumproduct function in
may ways:

sumproduct(--(c7:c20="client"),--(d7:d20="project"),(h7:h20))

or

sumproduct((c7:c20="client")*(d7:d20="project"),(h 7:h20))

or also

sumproduct((c7:c20="client")*(d7:d20="project")*(h 7:h20))

But last one could produce errors if (h7:h20) contain a single text
entry.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Marcelo and Franz,

Thanks but these didn't help.
Any other suggestions?


Why didn't help? What is the result?


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy