I have a problem to use vlookup in excel. I have an excel to run macro and other than i have two excel. One of them is list just a column which includes SAPkeys of people it looks like
SAP Key
xxxx
yyyy
xxxx
and i have another excel which i use as database. in this database sap keys of all people are written in "C" column. and there are other information about that person is written in "D", "E" and "F" columns.
what i want is bringing all information belong to sap key is written in different sheet. it would be like that after the macro run
SAP Key Name Location
xxx john london
yyy
zzzz hanks berlin
how can i do that. thank you for help!