Should be very easy to do this, yet... (GetValueIf)

[Jennifre]

Hi, I need to get the value of certain cells if certain other cells match. Example:

EM + DG have the values I need them to match, and if they match, I need to getvalueif of other columns.

Like, a GetValueIf (of column ES) of the rows where the value in EM matches that of DG.
EM43 = 1111
DG2 = 1111
Then get value of ES.

If there were a GetValueIf formula, it could be, =GetValueIf(DG2:DG37=1111),ES

In my way rudimentary formula-writing... guess attempt. *I am okay typing in the 1111.* Though I think that a multiple criteria matching effort might be the way to go, so it matches the value in two different columns, then gets the value of a third column?

If anyone's able to make sense of my effort here, please let me know. Thank you!!

 

[bryonwoods30]

for your problem

EM43 = 1111
DG2 = 1111
Then get value of ES.


choose the cell where you want the value from es to be placed.
enter the formula =if(em43=dg2,es,"")

 

[Jennifre]

Hi thanks BryonWoods30, though I get a "#NAME?" error with this.

What [if anything] goes in the "" ?

Thanks again,
- j

 

[bryonwoods30]

the "" is the value you want to go in there if the 2 cells don't equal each other. i have "" there so it stays blank if they don't.

 

[Sanjeev1976]

Hi,

You get a name error, since you have not put the cell reference properly

=if(em43=dg2,es,"")

replace the "es" in the above formula with the correct cell reference say "es5" or whatever is applicable.

Sanjeev

 

[Jennifre]

Ah, so, um, isnt' this basically just as much work then as to going to that cell and copying its value?

I was really hoping to match two columns to certain numbers, and if those two numbers matched in those two columns, then get the value of the third column.

Is that possible? Something like:

=GetValueIf(ES=1111 or 1112 and DG=1111 or 1112),[get value of]EL

 

[Sanjeev1976]

For the below requirement

=GetValueIf(ES=1111 or 1112 and DG=1111 or 1112),[get value of]EL

you can use a formula :

=if(and(ES*=1111,DG*=1111),EL*,"")

* represents the cell reference