Copy vlookup value to adjacent cell

[Patrick72]

Greetings,

I am having an issue getting a vlookup value to populate to a cell that is adjacent to my formula cell.

My formula:

=IF(NOT(C20=("VUMC"))," ",VLOOKUP(C21,Data!I2:J14,2,FALSE))

Lets say the formula is in D2 of sheet1. I would like the resulting value which displays in D2 to be copied to C2 and update when/if the vlookup changes.

If the criteria of the lookup is not met, I want C2 to remain blank

The Vlookup is from another sheet(Data!) in the workbook.


Any help is appreciated,

Patrick

 

[etaf]

the " " will put a space into the cell NOT a blank
"" is a blank

=D2
will copy what ever is in D2 into cell C2
and when C20 does NOT = "VUMC" it will be blanl

=IF(NOT(C20="VUMC"),"",VLOOKUP(C21,Data!I2:J14,2,FALSE))

Data!I2:J14
is this a typo - needs a column reference