VBA to Show Cell Content !

[ionelz]

Hi,
I have Range J9:K25 and Range AA2:AB37
Data in range J2:J25 is in AA2:AA37
I need this :
When I Click on K9:K25 to Show at I7 data from AB2:AB37 this way :

I7=VLOOKUP(J9,AA2:AB37,2,0) this should happening when I click adjacent to to J9 (so in K9)

 

[ionelz]

Or a Formula if possible would be better.