Comparing data in both columns against a list in excel


Comparing data in both columns against a list in excel



enter image description here



So what i'm trying to achieve is that :
C1 will return a result(match/not match) when comparing both A1 and B1 against E2:F18 list



I tried to put on =IF(A1:B1=E2:F18,"LMAO","Z"), that was my rough idea and apparently it doesn't work.



Please help





By match you mean the two columns match the same row?
– kabanus
Jun 30 at 9:32





yeap that's correct
– Jesse
Jun 30 at 10:09





stackoverflow.com/questions/21392307/… - I daresay you are getting downvoted because this is so easy to Google and already find an answer "excel composite key lookup"
– JGFMK
Jul 1 at 11:23










By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

.

Image
. - 0+ 967 : , , , . , . , , , . , , , . . : http://iplayer.org/game/charmfarm/ , , . , , , . , , . . , , , , . , . , , , . , , . , , . , . , . . , , . , ... . , . . . , , . , . , , . . . . . , , . , , . , , . . . . . . . , . . , . , . , . . , . . , . , , . , , - . , , . , . , . ...
Read more

Delphi Android file open failure with API 26

Image
Delphi Android file open failure with API 26 I can open files on Android with the Delphi code shown below. But when I compile it at API 26, it gives the error I added in the picture below. How can I solve this problem? ExtFile := AnsiLowerCase(StringReplace(TPath.GetExtension(yol), '.', '',)); mime := TJMimeTypeMap.JavaClass.getSingleton(); ExtToMime := mime.getMimeTypeFromExtension(StringToJString(ExtFile)); Intent := TJIntent.Create; Intent.setAction(TJIntent.JavaClass.ACTION_VIEW); Intent.setDataAndType(StrToJURI('file:' + yol), ExtToMime); SharedActivity.startActivity(Intent); Thank you so much for your help. I'm glad that I finally came across this kind of understanding person on this platform. I tried the .pas file you sent. but I see a different error window. I share my codes and the error. thank you so much. var ExtFile,yol,deger,id:string; mime: JMimeTypeMap; ExtToMime: JString; Intent: JIntent; javafile:JFile; begin yol:='/sdcard/SkyWiFiDownloa...
Read more

Amasya

Image
Not to be confused with Amasra. City in Amasya, Turkey Amasya City Amasya Coordinates: 40°39′00″N 35°49′59″E  /  40.65000°N 35.83306°E  / 40.65000; 35.83306 Coordinates: 40°39′00″N 35°49′59″E  /  40.65000°N 35.83306°E  / 40.65000; 35.83306 Country Turkey Province Amasya Government  • Mayor Cafer Özdemir (AKP) Area [1]  • District 1,729.69 km 2 (667.84 sq mi) Population (2012) [2]  • Urban 91,874  • District 133,133  • District density 77/km 2 (200/sq mi) Website www.amasya.gov.tr Amasya (Greek: Ἀμάσεια ) is a city in northern Turkey and is the capital of Amasya Province, in the Black Sea Region. Tokat from east, Tokat and Yozgat from south, Çorum from west, Samsun from north. The city of Amasya ( Turkish pronunciation:  [aˈmasja] ), the Amaseia or Amasia of antiquity, [3] stands in the mountains above the Black Sea coast, set apart from the rest of Anatolia in a narrow valley along the banks of the Yeşilırmak River. Although near the Black Sea, this area is high above the...
Read more