I want to use vlookup to find more than one entry from a table. e.g red 1 red 2 blue 12 blue 45 I want to run vlookup so that it will look up red and return 1...

I want to add different colors on toolbar to fill cell color. Not having to click on fill color box on toolbar to color cell each time.

I have a database that i'm working on. There are 5000 contacts. I have to figure out if a contact has had their car serviced in december to receive a svc....

I have these array formulas that I want to copy down to other...

on one wkst i'm only using rows 1-284, but when i use the scroll bar it goes all the way down to like 700 something, i want it just so when i move the scroll...

I am working on a reimbursement spreadsheet for our company's dental plan. I need to find out how to set it up to pay up to a certain amount. For example, if...

I just downloaded Crystal Ball to use with Excel, so that may be part of my problem. When I copy formulas, Excel won't calculate them correctly. Even if...

hi, i am typing a formular in a cell but instead of showing the result it is showing the formula....how can i change the cell format to show the...

Hello. I have a class that has 4 rows of seating. 8 in rows 1-3 and 5 in row 4 for a total of 29. I change the seating chart 8 times a year. My objective is...

I have to enter an opening amount for a day that equals the closing amount of the previous day.

I have 2 spreadsheets of unequal rows (Spreadsheet 1 = 20,000 rows, Spreadsheet 2 = 5,000 rows). Can I use IF, VLOOKUP, MATCH, or INDEX (or a combination of...

I am trying write a program using a macro that will create folders using excel, then transfer existing files to the folders and save the current file in that...

Hi I would like to know if i can add a or " to both ends of some text in many different cells. Is there a way of doing this?

The Merger and Center button appears to be "turned off". No matter which cell or range of cells I select, I am unable to use this button. Any suggestions...

I would like to combine numbers and text in the same cell, and sum the numbers at the bottom of a column. Is there a way I can do this? The text has no...

I have a spreadsheet with a column of ingredients, and another column with the percentages of each, not necessarily in order. Would I be able to express the...

Can you change the PMT function tio calculate off of 365 days instead of 360?

I need to create two formulas. One for overtime hours worked for 8-12 hours and then another one for overtime hours worked over 12 hours.

XL help not much help. I need to change the tab order for a protected worksheet. When the sheet is unprotected the tab key moves from left to right as...

I have a formula that is adding variuos cell values from different pages. It then goes and subtract this value from another value on another page. it...