Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP - Possibility of using a negative Col_index_num?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP - Possibility of using a negative Col_index_num?
In sheet 1 copy the cells with the names (A11:B16 ) and paste them to the
right of the dates (k11:L16). In sheet 2 cell B1 enter =VLOOKUP(A1,Sheet1!J:L,2,FALSE) and copy the formula down to all of the cells where you have dates on the left. "Amy K" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP - Possibility of using a negative Col_index_num?
I'm not sure if it's what you want, but this may be the formula you
need in B6: =INDEX(Sheet1!A11:A16,MATCH(A6,Sheet1!I11:I16,0)) Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |