Forum Discussion
Excel formula/function help! Please
Hello!
I have:
- 2 worksheets in same work book (worksheet Bill & worksheet Casey)
- each worksheet has Col A - client #s and Col D - status
Here's what I need to do.... I hope someone can help. Need to write a formula/function for the following:
When Casey updates her Col D (status) - I need Bill's Col D to update with that information
BUT: the rows may be different in each worksheet - sooo... when Casey changes her Col D, Row 1- I need Bill's Col D to check for a match in Col A (client#) ANY ROW.
So if we have client# 999999 in Col A, Row 1 on Casey's worksheet and she changes status for that client in her Col D to "On Hold"
Bill's Col D needs to check Casey's Col A, Row 1 client# to match to a client# in any row in Bill's Col A and if it does - populate Bill's Col D with the text from Casey's Col D, Row 1. ("On Hold")
2 Replies
HI
If you are only updating Casey and want bills information to mimic exactly what is on her sheet, Vlookup the client number from both cells. However, you will need to refresh the sheet each time you make an update to reactivate the formula. If you take the time to go to each cell and type =CaseyC2 etc, you can avoid the refresh. If it is a regular update and/or you add more clients over time, I would take the time to type the =CaseyCell#.
Hope that helps
The attached workbook has a simplified example with a VLOOKUP formula in Col D on Sheet "Bill". I just sorted Bill's list differently from Casey's to demonstrate that the order of Client#'s doesn't matter.
In Col E, i entered an example using INDEX/MATCH. Same result, different approach.
Is that what you need?
