held

Hi all, Probably a really simple answer to my question. I've written the below formula to give me a tel number in a cell if one is held on another sheet and to show no tel held if it isn't there. The final part of the formula works fine but if i hold a tel number is gives me #value ! error...

Good evening guys, This is my first post on forum and am looking forward to actively following threads. I am trying to get my head aroung matching cells in a row held in say 3 separate columns (b1,c1,d1). The data in the cells will be held on two sheets. I am looking to try to match data in...

I need to return data held in column AF, based on values in columns B and Columns BJ. Please can someone help ? :)

i have calculated the turn around time by using the formula =(NETWORKDAYS(E151,G151,$X$187:$X$191)-1)*("18:00"-"9:00")+IF(NETWORKDAYS(G151,G151,$X$187:$X$191),MEDIAN(MOD(G151,1),"18:00","9:00"),"18:00")-MEDIAN(NETWORKDAYS(E151,E151,$X$187:$X$191)*MOD(E151,1),"18:00","9:00") E is start date...

I hope I explain this so everyone understands. I have included a screenshot for some clarification. For every instance of "held" in column F, i want the corresponding cells A-E to be copied to another sheet. https://www.dropbox.com/s/k7mbt18510m766u/inside%20sales%202.JPG?dl=0 TIA

Can anyone help with what I thought would be an easy job? I would like to populate 13 TextBoxes (101 to 113) with data held in a range of cells. The following formula does the trick on a single box, but I'm going to end up with maybe 100 or more boxes to do. TextBox101.Text =...

Hi all, I'm trying to lookup every instance of a value (Vendor Name) and return the total sum of each of these rows value from another column (Retention Held). For example - When ABC Contractor is selected in cell R4, I want every instance of ABC Contractors on the Retention Register to be...