Hi. Im trying to get the cell reference (e.g. cell B4) from using the Vlookup function. I want to look up a particular value and then be able to change this value (i am using a userform). so basically ;

1 - I use a Vlookup in the userform to display a certain record
2 - Im trying to make it so this information can be changed and then an update button can be pressed so it saves the new information in the same location.

Any help would be much appriciated. Thanks.

Ant