Using results of VLOOKUP in another formula

[Guest]

We have a worksheet cell, where the field is populated by a VLOOKUP formula from another worksheet
We have another worksheet cell, where we want to use the value of the VLOOKUP result as part of an array formula
Unfortunately, it ignores the result and our formula doesn't work

For exampl

Contract ABC has a value of '9' in the VLOOKUP field. This value was VLOOKUP'd from a separate worksheet
We have an array formula that sums (counts occurrences) of all of those contracts that are for a specific office, and a specific dollar value that have this value '9'. However, this 9 isn't seen as a value and so, unless I then type over the '9' with a hard typed '9' the formula doesn't work

Is there another way I can accomplish this?

 

[Frank Kabel]

Hi
could you post your existing VLOOKUP formula. untiul then you may try
using the following instead of your formula
=VLOOUP(....)

try
=--VLOOKUP(....)

 

[Peo Sjoblom]

Try to put -- in front of the vlookup

=--VLOOKUP(lookup,table,2,0)

--

Regards,

Peo Sjoblom

We have a worksheet cell, where the field is populated by a VLOOKUP

formula from another worksheet.

We have another worksheet cell, where we want to use the value of the

VLOOKUP result as part of an array formula.

Unfortunately, it ignores the result and our formula doesn't work.

For example

Contract ABC has a value of '9' in the VLOOKUP field. This value was

VLOOKUP'd from a separate worksheet.

We have an array formula that sums (counts occurrences) of all of those

contracts that are for a specific office, and a specific dollar value that
have this value '9'. However, this 9 isn't seen as a value and so, unless I
then type over the '9' with a hard typed '9' the formula doesn't work.

 

[Guest]

The -- worked. Thank you

 

[Guest]

I will try the --suggestions you gave. Thank you, In the meantime

In worksheet #1, Column K, This is my VLOOKUP formul
=VLOOKUP(C3,'PMRS Data Dump'!$A$2:$B$7000,2,FALSE)

In worksheet #2, Here is my formula that uses the results of the VLOOKUP field in another formula.
=SUM(IF(AWDS!$A$3:$A$7001="LEMOOREOIC",IF(AWDS!$D$3:$D$7001<=2500,IF(AWDS!$K$3:$K$7001=9,1,0),0),0))

 

[Guest]

The -- worked Thank you

 

[Joshuavdh]

Hi

I know this is an old thread, but I also want to use the result of my vlookup in another formula. The =--vlookup does not work and gives me #value!

I am using excel 2013 and I merely want to multiply the vlookup cell/result by another cell