matching and finding data between two spreadsheets

Hello - problems with matching data
Hello Everyone!

I am new to this forum but am hoping that you all will be able to help me!

Here is the scenario - I have two sheets of data.

I want a formula that will look up the code in M7 in sheet 1, find it and match it in sheet 2, then return the date which is in a different column on sheet 2

Does that make sense?

Thanks!

-Meg

Not sure if my last post went through. - is there any way you can show me the exact way the formula would work?

VLOOKUP can be accessed by clicking on the fx button top left corner of an Excel spreadsheet. The function will look for a specified value (Lookup_Value) in an alphabetically/numerically sorted data range (Table_Array) and return a value specified by its position from the left side of the data range (Col_index_num). You may need to add true/false to the Range_lookup depending on what results you are looking for. I cannot stress enough that the left column of the array you are looking in for your information MUST BE ALPHA/NUMERIC!!!!!
vlookup2.png
DOUBLE CLICK ON VLOOKUP

vlookup.pngFILL IN THE BLANKS

Thank you! I will give this a shot!