Esteemed Group,
I would like to know if there is a formula that would allow you to type ian
in a cell and have it look up and find Giant Wing in a list of unique
words. Please see the attached example.
Thank you very much for your help.
John
--
VLOOKUP(*H4*,E:E,1,0)
On Fri, Oct 21, 2011 at 4:49 PM, John A. Smith johnasmit...@gmail.comwrote:
Esteemed Group,
I would like to know if there is a formula that would allow you to type
ian in a cell and have it look up and find Giant Wing in a list of
unique words. Please see the
Thank you Ashish for your quick and very enlightening response.
John
On Fri, Oct 21, 2011 at 7:28 AM, ashish koul koul.ash...@gmail.com wrote:
VLOOKUP(*H4*,E:E,1,0)
On Fri, Oct 21, 2011 at 4:49 PM, John A. Smith johnasmit...@gmail.comwrote:
Esteemed Group,
I would like to know if there
Dear John,
Ashish's Solution is Fentastic.
Please see attached sheet with another options.
On Fri, Oct 21, 2011 at 4:49 PM, John A. Smith johnasmit...@gmail.comwrote:
Esteemed Group,
I would like to know if there is a formula that would allow you to type
ian in a cell and have it look up
Noorain,
Thank you, I love using offset and never tried the wild card approach. Two
excellent alternatives, thank you.
John
On Fri, Oct 21, 2011 at 7:42 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear John,
Ashish's Solution is Fentastic.
Please see attached sheet with another