Hi All
I asked about this in the excel formula forum and they have pointed me here.
Basically I have the following formula working well in google sheets
breaking it down - the if statement is there only to make the cell blank and pretty before there is anything populated in the cell, the cell I9 is usually one word but sometimes it is 2 and those words are split by a / and spaces on either side (so looks like Charm / Tenacity or similar).
IF there are 2 words I would like the UDF to vlookup both words and figure out the value associated with those words and use the highest value when compared to each other and then add these with a value in H9 that is populated via other means.
Here is a link to the workbook with the working cells as done in google docs
https://docs.google.com/spreadsheets...it?usp=sharing
And I have attached the file in question as well.
Thanks in advance
Rey
Bookmarks