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:
( 180 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
(45 Ulasan)
4.9

23 freelancer menawar pada rata-rata $14 untuk pekerjaan ini

$30 USD dalam 0 hari
(477 Ulasan)
8.0
eltamarisa85

A proposal has not yet been provided

$10 USD dalam 1 hari
(157 Ulasan)
6.4
$10 USD dalam 40 hari
(158 Ulasan)
6.5
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
(40 Ulasan)
5.3
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
(40 Ulasan)
5.0
jaydeepniper2011

A proposal has not yet been provided

$10 USD dalam 1 hari
(13 Ulasan)
3.9
$15 USD dalam 40 hari
(3 Ulasan)
3.4
$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
Ahaleem123

i have good command over Ms excel especially Povit table, Charts, Advanced formulas etc. Do let me know more detail in PM Relevant Skills and Experience Ms Excel formulas Proposed Milestones $10 USD - upon completion

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