Forum Discussion
Help with conditional formatting
Below is the screenshot of my spreadsheet:- I’m currently on the tab Oct23, this is the start data. Next tabs is Nov23, Dec23 and so on. What I’m wanting to do is add the new data to N...
For some reason this doesn't work, tried in a number of different orders. Best I can get is every cell red. Even tried =XLOOKUP($A2, Oct23!$A:$A99, Oct23!B:B) (Adding $A:$A99 in each formula)
What's the B:B at the end?
Guess I'll have to stick with the first way. Might try find someone to send the sheet to and ask if they can set it up and send it back. Would that work??
What's the B:B at the end?
Guess I'll have to stick with the first way. Might try find someone to send the sheet to and ask if they can set it up and send it back. Would that work??
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Sorry - my mistake. The formulas should have used Oct23!C:C instead of Oct23!B:B.
See the attached version.
- 1st_Try - is the 1st details you gave, this works (I think)
Xlookup - is what I'm struggling with, cannot seem to get that working.
https://drive.google.com/drive/folders/1v8loMjCktN7xcz4SQeFACL47WdBsCS9f?usp=sharing
