trying to set a vlookup function in excel vba instead of worksheet formula.
what i wanted is whenever i put id no. in my sample format(sheet1 Range "C3"), details will show automatically as vlookup formula
in worksheet, data base lookup is in (sheet2).
kindly see sample attached file.
Thanks guys in advance and more power!