I have an Excel file which contains two sheets. Both contains some data. I have to find common records of the two sheets(i.e., records which are present in both sheets). I can do it manually, but is there any tools/functions which exist to do this?
Answer
You might be able to use VLOOKUP depending on how complex your key structure is.
(Do a search on the Microsoft Office Support website for VLOOKUP.)
No comments:
Post a Comment