Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am just looking for a function by using which I can find out the meanings
of a word typed in a particular cell in an another cell ? Is it possible? If yes, how? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You would use a VLOOKUP function - set up a table somewhere with the
words listed in one column and their meanings in the next column (suppose this occupies M1:N100). Then with the word you want to find being entered in A1, put this formula in B1: =IF(ISNA(VLOOKUP(A1,M$1:N$100,2,0)),"Not found",VLOOKUP(A1,M$1:N $100,2,0)) If the word doesn't exist in the table you will get the "Not found" message. Hope this helps. Pete On Aug 30, 7:58 am, vicky wrote: I am just looking for a function by using which I can find out the meanings of a word typed in a particular cell in an another cell ? Is it possible? If yes, how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel, what is the meaning of " ^ " symbol in a formula? | Excel Discussion (Misc queries) | |||
Formula Meaning In English | Excel Discussion (Misc queries) | |||
Formula Meaning | Excel Discussion (Misc queries) | |||
Word found no merge fields in your main document. | Excel Discussion (Misc queries) | |||
resolving a numeric cell entry for its meaning | Excel Worksheet Functions |