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

Render GeoTiff to on browser with leaflet

Render GeoTiff to on browser with leaflet I have a big GeoTiff Image with following gdalinfo : Driver: GTiff/GeoTIFF Files: ImageNew.tif Size is 8501, 8544 Coordinate System is: PROJCS["WGS 84 / Pseudo-Mercator", GEOGCS["WGS 84", DATUM["WGS_1984", SPHEROID["WGS 84",6378137,298.257223563, AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]], PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]], UNIT["degree",0.0174532925199433, AUTHORITY["EPSG","9122"]], AUTHORITY["EPSG","4326"]], PROJECTION["Mercator_1SP"], PARAMETER["central_meridian",0], PARAMETER["scale_factor",1], PARAMETER["false_easting",0], PARAMETER["false_northing",0], UNIT["metre",1, A
Read more

How to get chrome logged in user's email id through website

How to get chrome logged in user's email id through website I visited wishfin.com and one minute later I received their promotional email. I know this could be by chance but I am curious to know that if it is possible to get chrome logged in user's email id through website e.g. javascript ? Sorry, if this question is not relevant but I Googled it too, I have got no clue. javascript 1 Answer 1 Access to the chrome profile information is controlled through the chrome.identity API - specifically getProfileUserInfo. Docs It returns the email & a UUID for the signed in profile. However you must give the website permission for them to get this data, specifically the identity.email permission. Unless you gave them the permission, the website did not receive your email from google chrome. By clicking "Post Your Answer", you acknowledge that
Read more

using states in a react-navigation without redux

using states in a react-navigation without redux as written in the react-navigation page: Warning: in the next major version of React Navigation, to be released in Fall 2018, we will no longer provide any information about how to integrate with Redux and it may cease to work. In the next version of react-navigation it could be hard to use redux with react-navigation. My question is: what can I do to use states (and passing states between screens) in a react-navigation app without using redux? 2 Answers 2 For children of navigator react-navigation gives you an withNavigation HOC, so you can easily wrap the component inside it to access the navigation state and navigate. withNavigation Why you integrate react navigation with redux? For me, I want to be able to perform navigation actions from outside of my components(screens). Eg: Redux-saga. If we don't integrate, we can't navigate via red
Read more