I have two spreadsheets in an excel file. One looks like this:
Second one looks like this:
Now, I need to fetch Price in Spreadsheet 1 based on Date and Name from Spreadsheet 2. Please help.
Tried using Vlookup but it is fetching the first match but I need to compare two values in two columns together.