Satisfying 2 conditions and lookup from a 3rd column to return a v

[Raj]

Hi,

I have 2 columns - Document Type and System Numbers. Based on this, I have
to look up the date when this is occuring. i.e. Column A - Doc Type, Col B -
System #, Column C - Date. this data is available in 1 spreadsheet. Now I
have to transfer this into another spreadsheet in a format that tracks
progress of this document.

I am trying to figure out how "If Cell A1 and Cell B1 on Spreadsheet 1
matches Cell A1 and Cell B1 on Spreadsheet 2, then look up the date against
it on Spreadsheet 1"?

Any help is appreciated. Thanks in advance.

Raj

 

[Pete_UK]

You could insert a new column C on Sheet1 and enter this formula in
C1:

=A1&B1

Copy this down.

Then in Sheet2 you can enter this formula in C1:

=VLOOKUP(A1&B1,Sheet1!C,2,0)

Format the cell as a date, and copy down as required.

Hope this helps.

Pete