I've concatenated two cells together and have done a VLOOKUP on the
concatenated cells.
"L. S. Martin" wrote:
> I need to perform a lookup based on information shown in 2 adjacent columns
> (Col. A = Date, Col. B = UserID). Say the column with the information is in
> column C. Have no problem looking up based on just Column A, using
> VLOOKUP(look_upvalue, table_array,MATCH(lookup_value, lookup_array,
> match_type), FALSE), but it stops on the first entry for the date. I need
> to look up info. for a certain user ID on a given date. After looking in
> Help, it looks like INDEX might work, but I don't know how to set it up.
> Any help would be greatly appreciated.
> Thanks,
> LSM
>
>
>
Bookmarks