Hi
I was wondering, is it possible to edit the vlookup formula so that it ignores context and only looks for certain predefined terms from a list. For example: Vlookup "silty clay" in a column where it says "slightly silty clay"?
Or is there a search type function that would retun just specific text (predefined in a list) and ignore the rest of the context?
Thanks
Best regards,
Marius
Bookmarks