Kiloelectronvolt
Board Regular
- Joined
- Oct 5, 2015
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
Hi All,
I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference:
Business name in A1 and address in B1.
Example: Ebay 1123 Fake Street
On my second sheet, I want to type in Ebay, and if I type in the wrong address, it will highlight the address red .
I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference:
Business name in A1 and address in B1.
Example: Ebay 1123 Fake Street
On my second sheet, I want to type in Ebay, and if I type in the wrong address, it will highlight the address red .