Hi Forum,
What I want to achieve is to be able to lookup a value in a cell containing text. The text for example is AxB.
In this cell i want to extract the first character, so "A".
I then want to use this value to lookup in a table with headers A,B,C,D,E
I want to report back the value that corresponds to the same row that the formula is in.
It's easiest to explain this with a worked example.
Bookmarks