Vlookup cell location?

[maxmadx]

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

 

[Greg Truby]

If you're using VLookup, then you know the column in question, so you just need the row. You can use MATCH(x,range,0) to figure that out. The rest is offsetting the appropriate number for cells from there.