comparison of two tables

[#1]

Hi,

  i need to compare each column in two tables and select the value.

I have Region: table with Sales, Region and SubRegion: table with Sales_ID, SalesSubRegion.

now if i select the SlaesId it should show me the result of Region .

i.e SalesId: S01 the value it should return Ind in the Region.

Note: there is no primary key or common column provide me solution in this case

[#2]

Hi ,

Check the attached Qvw.

Regards

Saurabh

[#3]

Hi Saurabh ,

thanks for your sharp response,  i am getting result for this specific application.

but i am not getting the desired result if i am applung on another application let me share the sample excle sheet.

Here i need to select the BR_country and it should map with the CountryName2 to get the SubRegion.

can you let me know the approach

[ashfaq_haseeb]

Hi

BR_country  and CountryName2 Contain different values, you can't match them like thi.

You can create another column in Subregions sheet to map the the countries with BR_Country in main sheet.

Hope it helps

Regards

ASHFAQ