Dibatalkan

dont do vlookup if cell matches

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?

Keahlian Excel

Lihat lebih lanjut: excel macro format cell, php excel cell format, cell label format excel, php excel set cell format string, vba excel vlookup cell add macro, excel macro cell format check, cell address based vlookup result macro excel, whats best file format logos, myspace layout dont follow myspace format, excel dont format automatically comma separated data, whats best format megavideo, openoffice open document format template bid, import dates excel format dates dont read dates, excel dont repeat cell content

Tentang Pemberi kerja:
( 182 ulasan ) Melbourne, Australia

ID Proyek: #14925921

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 Lagi

$10 USD dalam 40 hari
(60 Ulasan)
5.2

22 freelancer menawar dengan rata-rata $14 untuk pekerjaan ini

$30 USD dalam 0 hari
(510 Ulasan)
8.0
$10 USD dalam 40 hari
(162 Ulasan)
6.6
eltamarisa85

A proposal has not yet been provided

$10 USD dalam 1 hari
(181 Ulasan)
6.6
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
(48 Ulasan)
5.5
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 Lagi

$15 USD dalam 1 hari
(42 Ulasan)
5.1
jaydeepniper2011

A proposal has not yet been provided

$10 USD dalam 1 hari
(14 Ulasan)
4.1
$15 USD dalam 40 hari
(7 Ulasan)
3.7
ank199018

A proposal has not yet been provided

$10 USD dalam 1 hari
(3 Ulasan)
3.1
$10 USD dalam 40 hari
(4 Ulasan)
2.5
$20 USD dalam 0 hari
(2 Ulasan)
1.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 Lagi

$20 USD dalam 2 hari
(3 Ulasan)
2.8
lsi1966

Hi. I’m interested in your project. I will complete this project correctly on time. Relevant Skills and Experience I have good experience and skill in data entry, excel/VBA, etc. Proposed Milestones $10 USD - when fi Lagi

$10 USD dalam 1 hari
(1 Ulasan)
0.0
$15 USD dalam 40 hari
(0 Ulasan)
0.0
$22 USD dalam 40 hari
(0 Ulasan)
0.0
$15 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 Lagi

$15 USD dalam 40 hari
(0 Ulasan)
0.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
infotechwebdev

We are professional and highly expertise in the area your requirement is. plz ping us if you like quality output and on time delivery. [url removed, login to view]~0119573f57d25ab8fd?viewMode=1 Relevant Skills Lagi

$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