Find a number in a column then return a value from another cell I have the follow data laid outs as follows; E F G H 1 No. Descr Ref Layout 2 1 Name1 1,2 (Name1 Here) 3 2 Name2 3 (Name1 Here) 4 3 Name3 4 (Name2 Here) (... 14 May 2010 08:25 Converting Excel to HTML Hi, Can you pls. help me How to convert excel to HTML and use pivots in HTML? Christ ... 14 May 2010 07:21 Countif gone wrong Hi, A B C D E 2000BC DEF DEF DEF 2000BC ABC 2000BC DEF 2000BC DEF 2000BC 2000BC 2000BC 2000BC 2000BC ABC 2000BC DEF DEF DEF This normally works but Im having a problem with it now. My formula looks like this =COUNTIF(Sheet3!A:A,"=2000BC")+COUNTIF(Sheet3!B:B,"=2000BC")+COUNTIF(Sheet3!C:C,"=2000BC")+COUNTIF(Sh... 14 May 2010 05:11 Limit Cell Content I would like to know how to limit a cell to only allow entry of the following number values of 1 decimal point. My limits are any value >=15.0 to <=100.0 as long the is only 1 decimal point. I'd appreciate any input. Bob Z ... 14 May 2010 13:56 How to have Sheet1 list Sheet2 rows matching text? I would like to have sheet1 list all rows in sheet2 matching "TEXT" in column sheet2,A. Big TIA! -JS ... 14 May 2010 05:11 How do I fill nonadjacent cells? I am working on some worksheets to keep track of activities of people in my group. They complete activities at a different rate of speed, and I want to show what has been accomplished so far. Thank you, ... 13 May 2010 22:41 Calendar Control missing Giday to you all, I'm trying to help fellow worker who have Excel 2003 and he does'nt have Calendar Control in Object dialog box. Even his computer in Windows\System32 has mscal.ocx, his Excel cannot insert Calendar Control because it's missing Thanks in advance -- deafo ... 18 May 2010 21:26 editing cells automatically??? Why is it that some spreadsheets will not allow you to edit cells automatically when tabbing between windows? i.e. some spreadsheets will require you to double click in the cell to continue editing once you navigate away from that spreadsheet. ... 13 May 2010 20:30 FORMULA'S WHEN DUPLICATING DATA USING =WORKSHEET1!A1, ON ANOTHER WORKSHEET WHY IS IT THAT IT CAN ONLY DO NUMBERS NOT TEXT I'M SURE THERE'S A WAY CAN ANYONE HELP THANKS IN ADVANCE ... 13 May 2010 18:17 Replacing one text with three in IF(ISERROR(FIND.......Max I have this formula. =IF(ISERROR(FIND("Relief",MasterTab!O21)),"",MAX(A\$1:A1)+1) can it be modified to find three different things instead of "relief". I'd like it to find: (FLM) (FL) and (M) ? Much thanks, Steve ... 14 May 2010 12:50