Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. modmac

    Vlookup Help

    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...
  2. modmac

    Vlookup Help

    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"...
  3. modmac

    General Database Question

    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.
  4. modmac

    General Database Question

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

    General Database Question

    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?
  6. modmac

    General Database Question

    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.
  7. modmac

    General Database Question

    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...
  8. modmac

    General Database Question

    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
  9. modmac

    General Database Question

    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...
  10. modmac

    #NA QUESTION

    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...
  11. modmac

    #NA QUESTION

    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...
  12. modmac

    countif using <>= in a range

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

    countif using <>= in a range

    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...
  14. modmac

    vlookup and cell formating

    That did it, Thanks again.
  15. modmac

    vlookup and cell formating

    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..
  16. modmac

    vlookup and cell formating

    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...
  17. modmac

    Align Combo Box in Excel

    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.
  18. modmac

    A cell that has both text and a link

    You know I did but what I forgot was the = sign at the begining. How Stupid. Thanks for the fast response.
  19. modmac

    A cell that has both text and a link

    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...
  20. modmac

    Selective printing rows/data

    This works great, Thank You very Much!!

Part and Inventory Search

Back
Top