vlookup - Retaining original cell value if blank is returned by vlookup

[ds2016]

Hi,

I am trying to use vlookup to match on a unique ID(Column A), and if a match is found populate the value in column B. However, if the match returns a blank value (As column B does not have a value, even though a match exists based on Unique ID (not an error) then I want to retain the original value of the cell.

Can anyone help me with the formula?

Appreciate it,
DS

Using Excel 2013.

 

[Aladin Akyurek]

Care to post the formula you have tried and indicate what the formula ordinarily returns, text perhaps?

 

[ds2016]

Care to post the formula you have tried and indicate what the formula ordinarily returns, text perhaps?

Right now the below is what I have, but this retains the value, if a match is not found. The solution I am looking for is; if a match is found and it is a value (text) then I want the value; however, if it is blank then I want the original value of the cell retained.


formula in Sheet 2

Cell # AP2
=IFERROR(VLOOKUP($D2,'Sheet1'!$A$3:$EW$2000,10,0), AP2)

 

[Aladin Akyurek]

Right now the below is what I have, but this retains the value, if a match is not found. The solution I am looking for is; if a match is found and it is a value (text) then I want the value; however, if it is blank then I want the original value of the cell retained.


formula in Sheet 2

Cell # AP2
=IFERROR(VLOOKUP($D2,'Sheet1'!$A$3:$EW$2000,10,0), AP2)

Why is it not D2, but AP2? Isn't D2 the original value?

 

[ds2016]

Why is it not D2, but AP2? Isn't D2 the original value?

Well d2 is the value I am matching (the unique ID), AP2 is the value in the cell I am writing the formula in. I want to retain the value in the cell I am writing the vlookup formula in, if a blank value is returned.

Again, if vlookup is not the correct formula, then I am open to other suggestions.

Below is another shot at explain what I am trying to do -

Sheet 1
Column A - Unique ID
Column J - The value I want to pull into sheet 2 based on a match

Sheet 2

Column D - Unique ID (to match to column a on sheet 1)
Column AP - Populate with value returned from column J, if not blank. If blank then want to retain the value in column AP. (Column AP is already populated with text)

Thanks,
Div

 

[Aladin Akyurek]

You can't have an entry in a cell and a formula in that same cell at the same time...

 

[ds2016]

You can't have an entry in a cell and a formula in that same cell at the same time...

Ok thanks. I'll try to figure out a diff way to get the relevant data.

 

[Aladin Akyurek]

Ok thanks. I'll try to figure out a diff way to get the relevant data.

It won't be formula-based, unless you use multiple cells which then can be concatenated into a single cell.

 

[ds2016]

Yes that's what I did. Just took longer.
Appreciate your prompt response.

Thanks

 

[Aladin Akyurek]

Yes that's what I did. Just took longer.
Appreciate your prompt response.

Thanks

That's great. You are welcome.