i have a set of data
now i want excel to look up value 12345 from table 1 search table 2
and return with entire column
thus now making a table with 5 cloumns
and matched correspondingly how do i do that1 want
now i want excel to look up value 12345 from table 1 search table 2
and return with entire column
thus now making a table with 5 cloumns
and matched correspondingly how do i do that1 want
12345 | 1/2/2011 | 4/2/2011 |
12567 | 2/25/2011 | 3/20/2011 |
1257 | 3/20/2011 | 4/20/2011 |
12345 | 1/23/2011 |
12567 | 2/25/2011 |
3456 | 3/5/2011 |