Using results of VLOOKUP in another formula

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Hi
could you post your existing VLOOKUP formula. untiul then you may try
using the following instead of your formula
=VLOOUP(....)

try
=--VLOOKUP(....)
 
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
Click to expand...
formula from another worksheet.
We have another worksheet cell, where we want to use the value of the
Click to expand...
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
Click to expand...
VLOOKUP'd from a separate worksheet.
We have an array formula that sums (counts occurrences) of all of those
Click to expand...
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.
 
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))
 
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
 
Back
Top