Need help on Conditional Formating

[Gautam]

Hey Chandoo, I'm a great fan of your website. You are doing the excellent work. I need your help in one case. Suppose column "F" contains the list of dictionary words and the corresponding column "G" contains their meanings like: "F1" contains word - "origin" and the corresponding column "G1" contains its meaning - "birth". I've defined the name for the list of words in column "F" to "Words" and later I've created a drop-down using validations--->List---> =Words in column "A1". now I want if someone select a word from drop-down cell "A1", it automatically shows the meaning of that word into cell "C1". Suppose if I've selected the word "origin" from drop-down list "A1" conditional formatting verify the word from list of words in column "F" and shows the meaning of that word in cell "C1" [A1= "origin" verify the word from list "F"---> "F1" contains ="origin" corresponding cell "G1" contains its meaning "birth" and the same answer will show in "C1" = birth]. Hope to hear some from you.


Thanks/Regards

Gautam Sehdev

Gautam.sehdev28@gmail.com

 

[vijaySharma]

Gautam,


Welcome to Chandorg Forums.


I believe you can accomplish this using a simple VLOOKUP formula.


Cell A1 Contains the drop down...

in Cell C1 put the below formula


=IFERROR(VLOOKUP(A1,F:G,2,0),"Word Not Found")


This will search for the word from A1 in Column F and if a match is found will return the meaning from Col G.


The IFERROR part will take care of any missing entries in Col F.


HTH

~VijaySharma

 

[Gautam]

Thanks Vijay Sharma, I appreciate your help. I will give it a try and let you know how it goes.


Thanks/ Regards

Gautam Sehdev.

 

[Gautam]

Hey Vijay, I've tried as you suggested and it's working absolutely fine. Thanks for your great help. Also, could you please describe/ explain me the functioning of this formula so that next time I can apply it by myself. I mean to say how exactly it's working ? What exactly it's doing.