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?
21 freelancer menawar dengan rata-rata $14 untuk pekerjaan ini
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
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