ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Updating lookup table (https://www.excelbanter.com/excel-worksheet-functions/140629-updating-lookup-table.html)

DanTX

Updating lookup table
 
I have an sheet that allows users to select a name from a dropdown list and
previously entered comments appear. (VLOOKUP) The problem I have is if
changes are made to those comments I need to update the grid with the new
comments. For example:

A1 = (employee1, employee2, employee3)

A5 = VLOOKUP($A$1,$AA$1:$AZ$59,2) where AA1:AZ59 contains comments

Users then change the comments entered in A5. How can I copy those comments
back to the lookup table on the appropriate row? (Keeping in mind the
appropriate row changes based off what was selected in A1.)

Any help would be appreciated.




All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com