# Using results of VLOOKUP in another formula

G

#### 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?

F

#### Frank Kabel

Hi
could you post your existing VLOOKUP formula. untiul then you may try
=VLOOUP(....)

try
=--VLOOKUP(....)

P

#### Peo Sjoblom

Try to put -- in front of the vlookup

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

--

Regards,

Peo Sjoblom

Beth Dye said:
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.

G

#### Guest

The -- worked. Thank you

G

#### 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))

G

#### 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