Hi,
I have two table 1st consist of ISD number and in 2nd table I have range and country name.
From 1st table I took 1st 8 digit of ISD number. Now I want to find this 8 digit number follow in which country from my 2nd table. But there is no common column or any criteria in these two table, so I have added one more column in my 2nd table as ISD to make relation in two table still give me error. Please see the below error
My Formula is :
country = IF('Hyd Dec CDR 2018 '[Call Type]="ISD",IF(AND('Hyd Dec CDR 2018 '[ISD Type]>=RELATED(Sheet1[End Area Code2]),RELATED(Sheet1[End Area Code2])),RELATED(Sheet1[Country]),'Hyd Dec CDR 2018 '[Call Type]))
Error
The column 'Sheet1[Country]' either doesn't exist or doesn't have a relationship to any table available in the current context.
1st Table (Hyd Dec CDR 2018) 2nd table ((Sheet1)
| finalCalledPartyNumber | Call Type | ISD Type | ISD Type | | Country | Start Area Code | End Area Code | Call Type |
| 0018043000 | ISD | 00180430 | 00180430 | | US & Canada [Toll-free - 001844] | 00184400 | 00184499 | ISD |
| 00440140771 | ISD | 00440140 | 00440140 | | US & Canada [ISD] | 00188900 | 00188999 | ISD |
| 0044012682 | ISD | 00440126 | 00440126 | | US & Canada [ISD] | 00187800 | 00187899 | ISD |
| 00440140771 | ISD | 00440140 | 00440140 | | US & Canada [ISD] | 00186700 | 00186700 | ISD |
| 0018004428 | ISD | 00180044 | 00180044 | | US & Canada [ISD] | 00185600 | 00185699 | ISD |
| 0018004428 | ISD | 00180044 | 00180044 | | US & Canada [ISD] | 00184500 | 00184599 | ISD |
| 0018004428 | ISD | 00180044 | 00180044 | | US & Canada [ISD] | 00180100 | 00180199 | ISD |
| 0018004428 | ISD | 00180044 | 00180044 | | US & Canada [ISD] | 00180000 | 00180099 | ISD |
| 0018004428 | ISD | 00180044 | 00180044 | | UK | 00440000 | 00449999 | ISD |
| 0018004428 | ISD | 00180044 | 00180044 | | | | | |
| 00440140325 | ISD | 00440140 | 00440140 | | | | | |
Please help,
Regards,
Sandeep Joshi
