Hi,
I've been working with this workbook for days now and need some help from the pros. I'm trying to use a lookup function for a set of data that looks like the attached:
I need it to search the sheet by the login id (hilighted in example), and return the 2nd and 6th # values (hilighted in example) in the row that starts with Grand, which is the first occurrance of grand in Column A after that specific login ID occurs in column D.
This is making me crazy, i'm not sure if i can do this with a formula, a table, or a macro. Any excel geniuses out there that can help me?
Bookmarks