Joneye
Well-known Member
- Joined
- May 28, 2010
- Messages
- 777
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
The Goal
What I tried and it failed
- To look up the first 3 digits of the OFFICE Phone (Column E), match them in Column H and return the value in Column G
What I tried and it failed
- I created this formula =INDEX($H$3:$H$5,MATCH(LEFT(E4,3),G3:G5,0)) in Cell D4 and it returns N/A
- What forumla do i need to learn more about that can deliver the answers in ive manually entered in Cell D3,D5 & D6
A | B | C | D | E | G | H | |
Name | Billing Country | Billing County | Billing Town/City | Office Phone | TOWN | Dial Code | |
Shop 1 | USA | Town A | 218-847-4444 | Town A | 218, 580 | ||
Shop 2 | USA | 5808128888 | Town B | 269 | |||
Shop 3 | USA | Town B | 269-382-4578 | Town C | 800, 631 | ||
Shop 4 | USA | Town C | 800-237-7777 | ||||
Shop 5 | USA | 5807987111 | |||||
Shop 6 | USA | 631-207-2222 |