I want to lookup a value of intersecting cells, find rate for specific trip. The rates are now summarized in a table by looking up first column and top row...

Hi Please help! I have a long list which i have named in one worksheet. In another sheet i refer to that list by applying data validation, so if you click...

How do I export or transfer an Excel spreadsheet to a flash drive?

In Cell $A$1 I insert a certain date. What formula (or combinations thereof) in another cell would derive the date of FIRST Saturday in the month of the date...

Any suggestion/formula to count the number of times the character "+" is present in $A$1? Thanx

=IF(J13="PASS",IF(I13=60,"FIRST CLASS",IF(I13=50,"SECOND CLASS",IF(I13=35,"THIRD CLASS","FAIL"))))":

Dear all, I have been provided with an Excel spreadsheet by a colleague. The workbook has several worksheets, one for each risk identified on the project...

Hello to all I Enter My Vlookup Formula it give me #N/A Which is Right There is no Problem with VLOOKUP Formula Now i want to give Condition If there is any...

Column A has numbers in it and some of these match. Column B has numbers in it and some of these match. The columns are already sorted by A then B. What I...

I have a table that acts like it's two separate tables, i.e., when I insert a new row, the last three columns don't have the inserted row. When I look at ...

Hi, Could you please explain how I can go about of looking up the value as table below 2 Weight Inside Dia 3 Nom K-55 C-75 N-80 4 20 94 19.124 ...

Help! I protected a worksheet and checked all boxes so that user can have acces to all features such as copy, cut, format, edit, etc. (except the formulas). ...

Sheet1!L53 = true or false Sheet1!L56 = true or false Sheet1!L59 = true or false so how do I get : if all true = good if all false = not good if any 2 are...

Hi all, Looking for a shortcut to help with a new workbook. I created a book for the month of January. Next, was a copy and paste for the month of March. ...

Hello. Trying to figure out how to configure it so that a daily csv is imported to the proper column and...

Hi I am inputting dates as text into a column, that are called for in another column. Okay when the first first column holds dates, but when the cell is...

Hi, A B 1 Male 2 Male 21/06/71 3 Female 08/11/68 # 4 Male 11/04/70 5 Female 6 Female 19/10/69 ...

Hi, i need a formula that retrieve data if one of two criteria is met. I need the formula in "C". If A1 or B1=Sheet2!A1:D25,retrieve content of cell...

using the vlookup, ,,, =Vlookup(A1,COSTSHEET!A;C,2,FALSE) there seems to be a problem with 2 , Lookup numbers ,, (ie), comming up #n/a for two item...

Hello to all I Enter My Vlookup Formula it give me #N/A Which is Right There is no Problem with VLOOKUP Formula Now i want to give Condition If there is any...