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

Advertisements

F

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(....)
 
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

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

Advertisements

Joined
May 29, 2017
Messages
2
Reaction score
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top