IF/Then but the answer be another cell if true???

[Jaesifur]

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.

 

[KillerOfGiants]

Assuming row 3 is your first row of data. Column B could look like this:

=IFERROR(VLOOKUP(A3,$C$3:$D$11,2,FALSE),"No")

where A3 is the term you are looking up in column A and $C$3:$D$11 encompasses the entirety of your data set in columns C & D.

 

[Fluff]

Another option

=XLOOKUP(A1,$C$1:$C$10,$D$1:$D$10,"No")

 

[Jaesifur]

Assuming row 3 is your first row of data. Column B could look like this:

=IFERROR(VLOOKUP(A3,$C$3:$D$11,2,FALSE),"No")

where A3 is the term you are looking up in column A and $C$3:$D$11 encompasses the entirety of your data set in columns C & D.

Thank you so much!

 

[Jaesifur]

Another option

=XLOOKUP(A1,$C$1:$C$10,$D$1:$D$10,"No")

You are both so amazing They both worked and fixed my problem. Seriously, 3000000/10 the MVPs for my sanity.

 

[Fluff]

Glad we could help & thanks for the feedback.