ifoundthetao
New Member
Hey all,
Sorry about the crappy title. Sometimes solving a problem has more about your ability to understand what the problem is, than actually "solving" it.
And unfortunately for me, my Excel vocabulary is a bit limited.
I'm building a Project Management spreadsheet, which I have attached (with dumbed down and sanitized data), that I'm having a bit of difficulty with.
I have three sheets in my workbook: TimeSheet, Invoices, and Project Table
TimeSheet is where the hours worked at logged. Each activity has a start stamp, and and end stamp, with some other information in there. There's also a portion to reconcile whether or not this Log ID has been invoiced. If it has, then there's a "Y" that appears in a column.
What I want, is for the Invoice Item ID to appear there, instead.
I've tried all sorts of VLOOKUPs, HLOOKUPs, INDEX, Array Formulas, creating of new columns to combine data to make it easier to get a hook in there, but I just can't quite get it out.
So, I'm leaning on your support, to help me through this.
Also, I posted this on Reddit.com's Excel board (http://www.reddit.com/r/excel/comments/1nzzxv/help_getting_a_specific_value_for_multiple_fields/), but I don't think that is very active over there.
Thanks again!
Sorry about the crappy title. Sometimes solving a problem has more about your ability to understand what the problem is, than actually "solving" it.
And unfortunately for me, my Excel vocabulary is a bit limited.
I'm building a Project Management spreadsheet, which I have attached (with dumbed down and sanitized data), that I'm having a bit of difficulty with.
I have three sheets in my workbook: TimeSheet, Invoices, and Project Table
TimeSheet is where the hours worked at logged. Each activity has a start stamp, and and end stamp, with some other information in there. There's also a portion to reconcile whether or not this Log ID has been invoiced. If it has, then there's a "Y" that appears in a column.
What I want, is for the Invoice Item ID to appear there, instead.
I've tried all sorts of VLOOKUPs, HLOOKUPs, INDEX, Array Formulas, creating of new columns to combine data to make it easier to get a hook in there, but I just can't quite get it out.
So, I'm leaning on your support, to help me through this.
Also, I posted this on Reddit.com's Excel board (http://www.reddit.com/r/excel/comments/1nzzxv/help_getting_a_specific_value_for_multiple_fields/), but I don't think that is very active over there.
Thanks again!