rcbricker
01-26-2007, 08:51 AM
Ok I am trying to learn some stuff to help me solve my many excel problems. So I don't bother you all so much.
I am trying to learn when to use and how to use the different functions in excel. I have a pretty good grasp of IF and VLOOKUP. I have some idea of OR and AND. I can use SUM pretty well. That is the extent of my comfort zone.
So I am looking to learn how to use the rest of the stuff in Excel. How do I go about learning this things?
Example:
Like if I had a range of data in Column A and I had some data that I needed to find in that range. There is no other data next to column A. What I would like to do is import the data that needs to be verified into a column and have a function run that will find the data in column A and bring back the cell address (like A14). WHat function will do this?
I am trying to learn when to use and how to use the different functions in excel. I have a pretty good grasp of IF and VLOOKUP. I have some idea of OR and AND. I can use SUM pretty well. That is the extent of my comfort zone.
So I am looking to learn how to use the rest of the stuff in Excel. How do I go about learning this things?
Example:
Like if I had a range of data in Column A and I had some data that I needed to find in that range. There is no other data next to column A. What I would like to do is import the data that needs to be verified into a column and have a function run that will find the data in column A and bring back the cell address (like A14). WHat function will do this?