I have some text in a cell that is
Order 10
Order 15
25 copies
10 copies
I need a formula that is going to look at the cell with the text in it, see if these variables are in that cell and then depending what variable it is output a specific value
So Order 10 would be 1:10
Order 15 would be 1:15
25 copies would be 1:25
and so forth
so far i have =IF(ISNUMBER(SEARCH('[Vlookup Tables VIP.xlsx]Variants'!$A$3,AL7)), "VARIANT", "IGNORE")
with the Vlookkup tables VIP being my looktabs.
Bookmarks