If cell contains then get beside cell

[graiggoriz]

Hello,

I don't know if formula or macro could help me but here is my question.

as per the attachment, I would like to get the amount when the cell beside contain a specific word.

I explain everything in the attachment.

Please get back to me if you need clarificartion. Many thanks,
Graig

[sktneer]

I think you forgot to explain your requirement in the attachment. Please upload the correct file with an explanation so that members can understand your requirement clearly.

[sakmsb]

Hello,

I don't know if formula or macro could help me but here is my question.

as per the attachment, I would like to get the amount when the cell beside contain a specific word.

I explain everything in the attachment.

Please get back to me if you need clarificartion. Many thanks,
Graig

looks like you haven't attached the correct file.

[Fotis1991]

Are you sure that you uploaded the correct file?

[Marc L]

Hi,

better is a crystal clear explanation in a post for those who can't (or don't want for security reason) open any attachment …

[graiggoriz]

Hi All,

I apology about that! I have replace the attachment.To provide further information, I will have in column where it regards the description of a article I bought. I need from that description to get the cell beside the description one to get the price.

In fact I manage to highlight all cell which contains the work I am interested in by selecting the column and CTRL+F but I would need the other column with the price.

I hope it is kind of clearer...

Thanks and sorry again.
Graig

[Fotis1991]

Your comment in D2 is:

..'IF(B2=CONTAINS MOLO* THEN D2;IF NOT NOTHING)

Do you mean?

Please Login or Register  to view this content.

[graiggoriz]

Fortis Many thanks. This is exactly what I needed :-D

For the other cell, about having the entire word equal to "MOLOKZ" should I use the same formula?

[Fotis1991]

Try this.

Please Login or Register  to view this content.

[sktneer]

I think the above formula will work perfectly if the column B2 contains a single word "MOLOKZ" but if the B2 contains a string as shown in the sample file, that wouldn't return anything as per the criteria specified. If this is the case, you may try this.....

Please Login or Register  to view this content.

[graiggoriz]

Thanks you all!

[sktneer]

you're welcome. Thanks for the feedback.