Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Satisfying 2 conditions and lookup from a 3rd column to return a v
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Satisfying 2 conditions and lookup from a 3rd column to return a v
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:D,2,0) Format the cell as a date, and copy down as required. Hope this helps. Pete On Oct 31, 12:21 am, Raj wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Column Heading after lookup | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
Lookup a row and column and return value | Excel Worksheet Functions | |||
Lookup values in one column to return another | Excel Worksheet Functions | |||
lookup from one column return value from another? | Excel Discussion (Misc queries) |