| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel, How to get cell reference of a particular word in anoth.
Hi, Actually I have to copy a value from one sheet to another which I had
done easily by typing '=' and then clicking on the cell in that sheet. But, I want to search for a word in another sheet, find the cell reference which is next to that word. For eg., In c5 value is 'YZ Bank'& in C6 value is 10 In D5 value is 'BC Bank'& in D6 Value is 16 What actually I need is, In a new sheet, I want to search for 'BC Bank' and get the value 16 from that sheet. Please help me with this. Thanking you Best regards. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif contains a word in a reference cell | Excel Worksheet Functions | |||
| Copy last cell with data in column E on one sheet to cell on anoth | Excel Worksheet Functions | |||
| How do I Reference an Excel cell in Ms Word | Excel Discussion (Misc queries) | |||
| formatting a cell to display a word when i enter a reference lette | Excel Discussion (Misc queries) | |||
| clicking cell containing text, and a numeric value appear in anoth | Excel Discussion (Misc queries) | |||
Threaded Mode
