Excel Formula That Checks Two Conditions
- or -
Post a project like this1722
£6(approx. $8)
- Posted:
- Proposals: 17
- Remote
- #2458616
- Awarded
Wordpress Developer *Full Stack Web Developer * Shopify Developer*PHP* REACT JS
Islamabad
190859628440566945762507136282333228431586498652810092283373724192373684472814086
Description
Experience Level: Entry
On the "companies" tab in column A we need a formula that looks at two conditions.
Look for B5 on companies tab in the look tab column A. If found then look for I5 (i for India) on companies tab in the look tab column H. When both pieces of data are found EXACTLY, then display the result "Found" in text on the companies tab in column A. If only 1 or 0 pieces of data are found, return the result "Not Found" on the companies tab in column A.
Preferably, I would like the searching on the Look tab to be done using a vlookup so that we can change the columns and results bring back on the companies tab.
Look for B5 on companies tab in the look tab column A. If found then look for I5 (i for India) on companies tab in the look tab column H. When both pieces of data are found EXACTLY, then display the result "Found" in text on the companies tab in column A. If only 1 or 0 pieces of data are found, return the result "Not Found" on the companies tab in column A.
Preferably, I would like the searching on the Look tab to be done using a vlookup so that we can change the columns and results bring back on the companies tab.
Chad M.
99% (18)Projects Completed
13
Freelancers worked with
15
Projects awarded
56%
Last project
16 Mar 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Please let me clear your job instruction I can't understand what you what
827120
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies