Healthcare Consultant
New Member
- Joined
- Apr 2, 2013
- Messages
- 4
I am not well-versed in excel formulas and am self-taught so, I have a hard time following some of the responses posted on here. I have Excel Version 2010.
I need a vlookup that will match two cells side-by-side against two other cells side-by-side. There are thousands of rows in both sheets, same file. I know the formula for a tradition vlookup but, in this case I need to match 2 for 2 and need help.
I can not combine the values with the concantenate function because the date cells will not format to match no matter what I do since they originated from access.
Please help me 'in lamens terms' with a formula that would do the following:
vlookup where lookup_value = '2 columns in table 1' and table_array = '2 columns in table 2', and col_index_num = 2 'from table 2'
Table 1<o></o>
<TBODY>
</TBODY>
Table 2<o></o>
<TBODY>
</TBODY><o></o>
I need a vlookup that will match two cells side-by-side against two other cells side-by-side. There are thousands of rows in both sheets, same file. I know the formula for a tradition vlookup but, in this case I need to match 2 for 2 and need help.
I can not combine the values with the concantenate function because the date cells will not format to match no matter what I do since they originated from access.
Please help me 'in lamens terms' with a formula that would do the following:
vlookup where lookup_value = '2 columns in table 1' and table_array = '2 columns in table 2', and col_index_num = 2 'from table 2'
Table 1<o></o>
5 Digit ID<o></o> | Date<o></o> |
15001<o></o> | 5/8/12<o></o> |
15204<o></o> | 2/5/12<o></o> |
15204<o></o> | 5/4/12<o></o> |
15204<o></o> | 6/7/12<o></o> |
16000<o></o> | 1/4/12<o></o> |
16005<o></o> | 5/7/12<o></o> |
17007<o></o> | 1/31/12<o></o> |
<TBODY>
</TBODY>
Table 2<o></o>
5 Digit ID<o></o> | Date<o></o> |
15154<o></o> | 5/1/12<o></o> |
15204<o></o> | 2/5/12<o></o> |
15204<o></o> | 5/4/12<o></o> |
15204<o></o> | 7/4/12<o></o> |
16044<o></o> | 1/1/12<o></o> |
16555<o></o> | 1/4/12<o></o> |
17007<o></o> | 11/31/12<o></o> |
<TBODY>
</TBODY>
Last edited: