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.
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.