Hey, I'm new to Excel so please bear with me and someone please for the love of both God and my job help me out.
Okay so I have two columns, A and C, which both have items in them. I'm wanting a formula in column B that can search A to find if there are any matches to C and if there are then to have the value of B equal to D.
That was a lot and I'm bad at explaining so let's try this.
I know that an =IF(A1=C1, D1, "No") will put the value of D, 3, into the B column. But my error is that the items in column A and column C aren't always in the same row. Like if I tried to do that for the Brown Tshirt then the result for this formula would be No because the two are in different rows. Is there a formula that would just go through all of C to find if there are any matches with A and if there are, regardless of rows, then the result would be the corresponding D value (which is associated with C).
I know this is super all over the place and probably really poorly asked, please be gentle with my ignorance.
Okay so I have two columns, A and C, which both have items in them. I'm wanting a formula in column B that can search A to find if there are any matches to C and if there are then to have the value of B equal to D.
That was a lot and I'm bad at explaining so let's try this.
I know that an =IF(A1=C1, D1, "No") will put the value of D, 3, into the B column. But my error is that the items in column A and column C aren't always in the same row. Like if I tried to do that for the Brown Tshirt then the result for this formula would be No because the two are in different rows. Is there a formula that would just go through all of C to find if there are any matches with A and if there are, regardless of rows, then the result would be the corresponding D value (which is associated with C).
I know this is super all over the place and probably really poorly asked, please be gentle with my ignorance.