| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transfer Comment to VLOOKUP Cell on Search
I have a spreadsheet that displays a cell's contents in column E based on a
numberical identifier in column B. These cells targeted by the VLOOKUP cell are located in a seperate part of the same worksheet. I would like to transfer the comment of the target cell along with the cell data when the VLOOKUP cell populates. Here is the basic VLOOKUP formula I am using: =VLOOKUP($B7,$Y$22:$AT$503,2) Thanks for any help straightening this out, in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show original comment in cell when using Vlookup in Excel? | Excel Worksheet Functions | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| How to get search and transfer | Excel Discussion (Misc queries) | |||
| Using Vlookup in a string search of a cell | Excel Worksheet Functions | |||
| Vlookup while pulling a cell color and comment | Excel Worksheet Functions | |||
Threaded Mode
