dont do vlookup if cell matches

Selesai Dipasang 6 tahun yang lalu Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

openoffice format,

Goal:

Doing a vlookup but if cell matches with one particular cell (h2)

Then have the vlookup return blank.

If vlookup doesn't match, do vlookup as normal.

Step 1 - open the attached file

I highlighted in Green what should show.

I highlighted in Red what should be blank.

Step 2 - Test

Whats in h1 of the spreadsheet?

Excel

ID Proyek: #14925921

Tentang proyek

18 proposal Proyek online Aktif 6 tahun yang lalu

Diberikan kepada:

renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $10 Lebih banyak

$10 USD dalam 40 hari
(71 Ulasan)
5.5

18 freelancer rata-rata menawar $15 untuk pekerjaan ini

eltamarisa85

A proposal has not yet been provided

$10 USD dalam 1 hari
(234 Ulasan)
6.8
Vasilchenko

Hello I can do this. Show details. I didn't get what you want in Q2, I hope you will clarify this. If you want 10$ budget please create hourly based project. Relevant Skills and Experience Excel Proposed Milestones Lebih banyak

$15 USD dalam 1 hari
(59 Ulasan)
6.2
sajibdigital

I am interested to work in your project. Please contact me on chat for more discussion, I am waiting for your response. Relevant Skills and Experience excel Proposed Milestones $10 USD - Initial

$10 USD dalam 40 hari
(62 Ulasan)
5.6
mohds2

Hello, I am a EXCEL EXPERT with Ms-Excel Related work Including Macros with 10 years of Exprience. Relevant Skills and Experience I have already completed About 2000+ On Various Freelance Websites Proposed Milestone Lebih banyak

$20 USD dalam 2 hari
(4 Ulasan)
3.0
ChethiyaKD

I can do this Relevant Skills and Experience I can handle MS Office perfectly Proposed Milestones $10 USD - mileston Send me the file

$10 USD dalam 40 hari
(0 Ulasan)
0.0
rozz000

I bid $10 for this project. Relevant Skills and Experience I have recently completed the PWC Problem Solving with Excel course from Coursera and looking for opportunities in data analysis using excel so that I can exe Lebih banyak

$15 USD dalam 40 hari
(0 Ulasan)
0.0
sonnyie

I can complete your project on time and within your budget. Relevant Skills and Experience I always doing similar to this. Proposed Milestones $10 USD - Data Collection $5 USD - Finalization

$15 USD dalam 40 hari
(0 Ulasan)
0.0
hendelhalaby

A proposal has not yet been provided

$10 USD dalam 2 hari
(0 Ulasan)
0.0