Hello,
I need assistance please.
I am trying to match id number to id number and names on a different sheet. i would also like to bring over all content once the match to the id numbers have been identified. What is the best option. i am trying to do a Vllookup but that is not going well.

Example:
Sheet 1: list of ID numbers
Sheet 2: All information, ID numbers, currency, etc.
Issue: bring both files together on sheet 1 only matching numbers from sheet 1 but bring in all data from sheet 2.

Thanks for your assistance.