Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |