Sep 28 2022 12:21 PM
I am trying to write a formula that would look something like:
=IF(B2=B1, Copy C2, None)
This formula would be in cell C1. If B2 matches B1 then copy the value from C2 to C1, otherwise do nothing.
Thanks for any help.
Sep 28 2022 12:24 PM
Sep 28 2022 03:16 PM
@mtarler Thanks for your reply. Strangely this is working for some but not all cells. Below is a sample where the A & S Electric (B Column) match triggered the C column match. But it didn't work for A Capital Electric, Inc. Any idea why?
A & S Electric Inc. | 16990 Other Electrical, 16951 Landscape/Outdoor Lighting, 16950 Lighting Package, 16800 Fire Alarm, 16700 Security/Tel/Data Systems, 16050 Electrical |
A & S Electric Inc. | 16990 Other Electrical, 16951 Landscape/Outdoor Lighting, 16950 Lighting Package, 16800 Fire Alarm, 16700 Security/Tel/Data Systems, 16050 Electrical |
A Capital Electric, Inc. | =IF(B33=B34,Q34) |
A Capital Electric, Inc. | 16990 Other Electrical, 16951 Landscape/Outdoor Lighting, 16950 Lighting Package, 16800 Fire Alarm, 16700 Security/Tel/Data Systems, 16050 Electrical |
Sep 28 2022 03:33 PM
SolutionSep 28 2022 06:42 PM
Sep 29 2022 05:14 AM
Sep 28 2022 03:33 PM
Solution