Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 70
Default Formula by which meaning of word can be found out in another cell

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Formula by which meaning of word can be found out in another cell

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, what is the meaning of " ^ " symbol in a formula? Anthony Excel Discussion (Misc queries) 2 October 6th 06 01:09 AM
Formula Meaning In English Dropdown3 Excel Discussion (Misc queries) 10 January 28th 06 03:11 PM
Formula Meaning Bevatron Excel Discussion (Misc queries) 17 January 10th 06 06:32 PM
Word found no merge fields in your main document. lburg801 Excel Discussion (Misc queries) 0 November 28th 05 08:01 PM
resolving a numeric cell entry for its meaning vtcrob Excel Worksheet Functions 0 February 4th 05 02:23 AM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"