Return different values according to the search word by performing multiplication

[Virtuallynne]

Hi

Thanks in advance for your assistance in helping my little brain from stop exploding

I need a formula to work similar, but more advanced to this:
=IF(ISNA(MATCH(TRUE,INDEX(ISNUMBER(SEARCH({"Beautiful","Day","Fish","Banana"},A1)),0),0)),"",B1)

The difference being that if the search word is "Fish" then it would return a different value to that of "Banana", which in turn would be calculated by multiplying 2 cells. The 2 cells would be unique for "Fish" and unique for "Banana"


Hope you can help and thanks heaps

[Jacc]

Something like this?

Please Login or Register  to view this content.

[Virtuallynne]

Hi,
Thank you for your reply
I have attached a spreadsheet to show what I am trying to achieve. Your help is so greatly appreciated.
I think it is similar to your formula, but slightly different. Eg, If blonde is entered into column A and 15" is entered into B, then the resulting value would be calculated by multiplying the quantity and price per gram.

[Jacc]

This seems to work:

Please Login or Register  to view this content.

This is an array formula, you have to enter it with Ctrl + Shift + Enter.

[Virtuallynne]

Yeah that looks like it's working. Thank you so much

[Jacc]

''''''''''''