Timeline for updating a cell with a concatenated reference from another sheet
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 11, 2019 at 20:22 | comment | added | Kimberly Mitchell | I've tried this and it doesn't add the value from the vlookup to the cell=IF(MID(K3,(LEN(K3)-5),7)="unknown",VLOOKUP(LEFT(K3,3),FinalFSOTbl!A:B,1,FALSE),"no sales office") | |
| Apr 11, 2019 at 19:58 | comment | added | Kimberly Mitchell | Thank you! Is there a way to automate this by adding code to a button to go through each line automatically and make the updates? | |
| Apr 11, 2019 at 19:33 | history | answered | Andrew Sainsbury | CC BY-SA 4.0 |