Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
VLOOKUP - Possibility of using a negative Col_index_num?
I have this workbook with two worksheets, Sheet1 and Sheet 2. On Sheet1, the user would enter dates on I11:J16. The corresponding names for the dates are located on A11:B16 (merged cell) On Sheet2, column A is a list of dates. I'd like for the formula to look at dates on Sheet 2, column A. If any of the dates on Sheet2 - Column A match on Sheet1 I11:J16, on the matching row of Sheet1, take the information from A11:B16 (merged cell) and place it into Sheet2, Column B. For example, on Sheet 1, there is a value of Feb 2 on I11. If Feb 2 is found in any row of Sheet 2 - Column A (say A6), I'd like to take the corresponding text on Sheet1 - A11, and place it in Sheet 2, B6. What is the best way to solve this issue? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup with different col_index_num | Excel Worksheet Functions | |||
VLOOKUP and using a Name in the col_index_num | Excel Worksheet Functions | |||
vlookup - Col_index_num | Excel Discussion (Misc queries) | |||
possibility of pasting numbers with negative sign placed after | Excel Discussion (Misc queries) | |||
Vlookup Col_index_num | Excel Discussion (Misc queries) |