Vlookup every letter in a text string.

[Isaactd]

Hi Guys,

When you have a chance this is the problem I'm trying to figure out.

I have a cell that contains text strings with different lengths.

I'd like to vlookup each of the single characters in this cell counting duplicates.

I'd like to find an exact match for each letter in the string matching letter, case and selected font from my table

Text= "Hello"

Font= beans


This is my lookup table: formula s in the 4th column

A bean uppercase

W bean uppercase

g bean lowercase

o bean lowercase

Finds a perfect match with "o" and returns 1.

If the looked up character cannot be found, in the example "H,e,l,l" cannot be found.


Then ask what is case of each letter? Then if lowercase search for letter "g" if uppercase ="w" now find exact match and add 1 to column D for every match you find if no match font show "error"


Here are some expected results of my formula text "Hello" matching "bean"

A bean uppercase=0

W bean uppercase=1

g bean lowercase =3

o bean lowercase =1

W apple uppercase =0

g apple lowercase =0


Any ideas to do this formula?

 

[GlennUK]

There is no ordinary formula function that can get you font of a cell. Why does this need to be a formula?

 

[Isaactd]

Hi Glen,

The font is not important thats just part of my data set in column b.

 

[Isaactd]

There are 3 columns of variables
A=Letter
B=Font
C=Case
D= Where the formula is I'm wanting to figure out.
E= TEXT LOOKUP VALUE
D= FONT LOOKUP VALUE

 

[Isaactd]

Dataset currently just w & g but I will add other letters in time

 

[GlennUK]

I really cannot grasp what you are aiming for. And, I'm guessing from the lack of other responses, that no-one else grasps it either.