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.
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...
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 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..
I have a worksheet where I'm using the vlookup function and it works well. In the row in which the vlookup is being used a value is being returned I then multiply it by another number and get a total. I have several rows that do this. If let say I only use 1 row the other two rows cells show a...
I have a worksheet that has approx. 20 Combo boxes, The boxes are in the same column one below the other and approx the same size. The question is how can I have all of them either snap to the cell behind them or get them the same size.
I have a work book that has several sheets, I would like to reference a cell from the 1st sheet and use it in a middle of a cell that has text in it. I want to put it in a certain point within the text string.
This is the text string:
Effective this 1st day of July, 2005 and continuing in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.