Vlookup & if then

**MikeOnMars** · 07-10-2013, 12:58 PM

=IF(ISBLANK(S6),"",VLOOKUP(S6,[FileExchange_Response_18973302.csv]FileExchange_Response_18973302.!$A$2:$D$252,4,FALSE))

Right now, IF S6 is blank then the active cell returns blank. I want: IF S6 is blank then the active cell does nothing.

Thanks.

**martindwilson** · 07-10-2013, 01:13 PM

what do you mean nothing? it cant return nothing

**MikeOnMars** · 07-10-2013, 01:23 PM

I want the active cell to retain the value it currently has.

**martindwilson** · 07-10-2013, 01:43 PM

if you have a formula in a cell you only get the result of the formula,i dont understand what value you want to have

**MikeOnMars** · 07-10-2013, 06:18 PM

I dont understand what's so complicated about this request. Let me make it simpler.

I am putting a formula in Cell A to say IF cell B is empty then leave cell A alone. . .

**martindwilson** · 07-10-2013, 06:29 PM

no thats not simple if you put a formula in a1 it must give an answer. what do you want it to say then,what is in a1 that you want to keep if say b1 is empty?

**FDibbins** · 07-10-2013, 06:29 PM

If I understand you correctly, you want to be able to have a value AND a formula in A1?

IF thats what you want, you cannot have a value/entry in a cell AND a formula - 1 or the other, not both

Or do you mean...

A1=if(B1="","",B1)

**MikeOnMars** · 07-10-2013, 06:32 PM

Is there anyway I could send you a sample of my worksheet?
Appreciate your help.

**martindwilson** · 07-10-2013, 06:36 PM

yep like this
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**MikeOnMars** · 07-12-2013, 04:55 PM

Sheet 1 is updated info that I want VLOOKUP to pull into Sheet 2.
On Sheet 2 I have written this formula in cell C2: =VLOOKUP(A2,'Sheet 1'!A2:D12,3,FALSE)
I want to be able to copy the formula and apply to the entire column.
The problem is that when Column A is blank, it will erase whatever is in Column C, such as C4, C5 and C7. I would like to write the IF(ISBLANK...) portion of this to say IF A is BLANK then DO NOTHING. Keep 74.99 in C4... etc. Thanks.

**mikeTRON** · 07-19-2013, 01:39 AM

Why not filter to exclude BLANKS then applly the vlookup formula, or create a helper column where you copy and paste value from C to F then use an if function to grab F if A is blank?