Recent content by modmac

Thanks for responding, but I'm not sure I explainined it well enough. On sheet 1 I will enter a value of either tht01234 or tht1234 in a cell (A2), I want it to look through columns A & B on sheet 2 and if it listed give me the value in column c, if not return a 0. Sheet 2 A B...

Hello, I'm trying to use vlookup to look through 2 columns and return the valve in the 3rd column. DATA: "A" "B" "C" tht1234 tht01234 35.7 kit0922 kit00922 456 Here is the fourmula I'm using, I can only get it to find the value from column "A" but not "B"...

Thank you all, You have all giving me the insight I needed. This project is way more then I want to take on without a professional programmer. Thank you Again.

Excel is not a database O.K. What do you recommend?

03Explorer, Thanks for responding. The real question is, is Access the best tool for what I want to do or is there someting else that would work better?

Skip, at this point I don't, but all I'm trying fiqure out what would work best for us ie: Excel Access, Sql, etc... Should I get a programmer involved now or later, should we manage it or a third party, is it feasible or not.. I did find some good references to look into.

Skip I was hoping you would respond to my inquiry, you have been a BIG help to me in the past. This data base is not going to be a enterprise wide data base just one department/division. I understand that management is a hugh issue. That is why I would like to keep it small and simple. I'm in...

Alex, Thanks for replying, it all helps. Regarding the multiusers we will have maybe 3 people using the database. That is entering the data, running the reports, running queries it's not going to be an enterprise wide use database. I will look ay MYSQL. Thanks

I have a general question and am looking for input. The company I'm currently employed with is using several different MS Access databases for recording and reporting. There are several problems, 1)they are all seperate databases, 2)people are using different versions of Access, 3) we have no...

Skip, Thank you for repsonding so quickly, I knew from past experience that I would recieve a quick reply. I didn't show the isna formula because when I tried using it I would always get the same result error. So all I had to do was to change the 0 to FALSE. I quess I need to study this more...

Hello all, I can't fiqure out the proper formula using ISNA. Basically if a number appears on another sheet then I want to the cell to state "Customer Requires a P.O. For Payment" othewise I want the cell to be blank. Here is the formula I have and it works except for the instead of a blank...

Thank You both, I ended up using macropod's since that is what I was already trying. Thanks Again.

Hello, I'm trying to count the number of times a value is meet. For example I would like to count how many times the number 7 and less(<) appear in a range then within that same range I would like to see how many times there is a number equal(=) to 8 and equal(=)to and less(<) than 14. I've...

That did it, Thanks again.

That worked, Thank you. Can you tell me why the range values change when I copy the formula down to the cells below. The Range value will increase by 1. for example the original range was PARTS!A2:B22872 after I copy it or drag it to the next cell the range is now PARTS!A3:B22873 and so on..