Search results

Eibi!!!!! Thank you, life saver. Was going down the path of IFERROR,INDEX,MATCH,INDEX ... this is much more elegant.

I've attached the sample workbook

Need some help, see the attached sample table In the table above, I'm going to have two values that I need to lookup First value is the "Average Days" (First Column) Second value is the "Actual Number of Days" (Which will be in a range between "Days Low" and "Days High") Between the two, it...

I normally wouldn't try this, but it would literally take a thousand words to represent what that chart does... it is a simple roadmap with each area of the pie representing a "bucket" of technology and the tools associated with that technology. Not to be argumentative, but I think that the...

Thanks!

I need to create a chart that looks very much like this one: http://blogs.technet.com/cfs-filesystemfile.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-00-84-12-metablogapi/7041.clip_5F00_image002_5F00_18B87D97.gif The inputs would be: 1.) Name of the pie slice (I'd prefer this...

Faseeh, thanks for responding... I actually found something that works in my situation: https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/data-validation/replace-choice

Faseeh, Not quite, in the picker, I want it to show "12345 -- Role Name -- Role City", however, once picked, the cell would only have "12345" in it.... I need that number to then do lookup's in another table. "12345 -- Role Name -- Role City" is a combined field. I have 3 of fields "12345"...

Hello Chandoo, I hope you can help. Hi Chandoo, Maybe you could help me. I need to do a customized Data Validation list. The parameters: The field to pull the list from looks like "12345 -- Role Name -- Role City" I want to see the whole string in the list picker, but only want to see...