Disappearing Text

[itsgrady]

I have four cells that I update with information throughout the day. These updates must be placed in a separate spreadsheet in a column for each update. I have an ID cell on both spreadsheets to identify the changes.

I would like for these new updates to be automatically placed in the designated column. I used XLOOKUP and it worked great in moving the information to the column on the other spreadsheet. However, whenever I make a change to the ID number, the information in the columns on the other spreadsheet disappears.

I understand why it disappears, but I am seeing this is possible to keep the information form disappearing with a different formula.

 

[Joe4]

You would probably have to hard-code the values, if you do not want to lose the value that came from the prior ID number.
That would probably require VBA.

If that is something you want to pursue, you will need to provide us with detailed information on your current data structure, formulas, and desired results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.