I need assistance in editing a portion of the formula below. As it stands this formula (which I have written into cell (AD4) WORKS, and does exactly what it...

A need to retrieve a price depending on three values Material, class and size Material = B5 Class = C5 Size = D5 Vlookup column table Sheet1 A4:H69

I have prepared salary scales using simple formulas where the calculations are based on a % increase. I would like the answers to be rounded up eg: $27.997...

COL A COl B COL C COL D COL E/exptcd Hypothyroidism Leg pains ...

For using of Ms excel; 1. When using copy “1� and pastespecial, select “multiply� on the cell that contain web or java script hyperlink, the...

I'm using the index function to lookup data from the web (web query). Curently I'm using 4 web query's to update information (set to refresh on opening the...

In Excel 2007, I use pivot tables to analyse income and expenditure. I would like to be able to deduct the expenditure from the income, but Excel seems to...

How can I identify if I have double booked an employee into a workshop and I’ve scheduled them at the exhibition booth? Do I use conditional formatting?,...

I am looking to solve the following problem Col A Col B Col C Col D Date received Date Processed Days taken Are days...

I have reduced the text size in an Excell work sheet. Is it possible to reduce the cell size to suit the text size.

Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I am entering the formula in column D. I want to look up data in column C and see...

I am trying to determine a formula for this DATA A B C D 1 Team 1 Team 2 Ump 1 ...

I'm helping my husband do a spreadsheet for work, and last time I had a question I came here and I got much needed help but that was a while ago and now I'm...

I have a couple of questions, I am managing 100 volunteers at a conference in Florida and they need to be assigned to sessions/workshops and an exhibition...

I am using this formula which works well if I am only trying to match 1 part number...

I am trying to get my tab button to jump to the unlocked cells only so that the user can go straight to the cells that they need to populate on my form...

I have several columns of information (i.e addresses) and one of the columns has duplicate numbers. I want to remove the duplicates rows and retain the...

Hi, I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if...

I have a workbook with different sheets within the workbook. On my code page I have a column with client, client code I have assigned to each client. I...

Hi, I was wondeirng if anyone can help me. Is it possible to have a vlookup be a part of an IF statement? In my Column L I need it to check in another tab...