Why is it that whenever I use Vlookup, the first col in both sheets should
be the same..as in, both should be ids, or names or whatever...and that
should be the value on which im using vlookup? any way i can get around
having to delete/hide lots of cols everytime i use vlookup?

Formula to compare a list of numbers in a row/column and obtain the highest

Formula to compare a list of numbers in a row/column and obtain the highest

Is there a way to make a link to a specific tab in excel? I have a workbook
with many tabs and I want to make an first page that has links to go to
specific tab when clicked.

How would I use and if statement based on between two numbers??
Example---
For cell A6:  IF A5 is between .99 and 5, 1, 0
A5 = .25 ....so A6 is 0

I have a spreadsheet that shows when certain professionals need to
submit a report by.
In column J I have a nested IF that will show if the report was
completed on time or not, or if it's still yet to be done, etc. This

Looking to use the inputted/select from drop down data in a cell to populate
other cells using data from another worksheet.
ie.
Worksheet 1 = Main Page

Say I have a Spreadsheet with 3 columns, and they are, Age, Gender, Location.
Then how could I count how many pieces of records there are matching certain
age, gender and location?
I know how to use SQL to get the data and numbers. But I would like to how

When you scroll down the page the conditional format box moves aswell so it
can sit next to a cell which the condition does not apply to.  
Instead can the conditional format box be locked next to the relevant cell
so when you scroll it stays with the cell it relates to?

I am trying to calculate various cells, not in a certain range, but it only
allows me to enter 30. Is there another function to calculate more than 30?

As i am working in financial services firm, i wanted to expertise in
financial functions in excel, Can anyone able to help me?

I can no longer insert new columns in between previously formed columns, and
can't unhide the hidden columns. Using excel help did not help. Any
suggestions?

i need to keep a running total down a column subtracting amounts from the
original figure

I've tried several functions alone and combined with the next problem, but
nothing work correctly.
Suppose I have two columns A i B - first with the personal names and second
with some score written in text: excellent, very good, good. I want to find

Good Morning, Experts:
I have a workbook with Macros and one of the worksheets is data that I have
copy/pasted from another application.  This application has a hidden column,
but pops that hidden column when I copy/paste it to the Macro'd Workbook.  I