Recent content by TOTCOM11

I've pretty much gotten it to work now. There are some spots in the lookup table that are blank. When the lookup on the main page comes across a blank, I want it to display nothing (AKA ""). Right now it is displaying a ZERO (0) and I don't want it to display anything. How can I get this to...

OK! I got it to work for BONE and TRIM. What I ALSO forgot to mention (sorry) is that for the occurances that F9 = "TIME", I want Excel put place the value from F18 into J22 (on the same sheet as the F9 lookup cell). How can I do this?

BTW.....AD8 is the cell I am using to find the particular record I'm looking for. I figured you could figure that out on your own, but just in case...

I forgot to mention two things. Yes, I am using VLOOKUP. Unfortunately I am trying to look something up that is on a separate worksheet in the same workbook. Here is the formula that I use to "manually" bring up (without the dropdown box) the values I want for BONE. =IF(VLOOKUP(AD8,'Product...

I have 3 items in a drop down in cell F9, BONE, TRIM, AND TIME. I am trying to get cell J22 to populate based on a lookup (which I currently have working) on different columns depending on what is in cell F9. I know how to do this using an IF Statement, but it can get very confusing to code...

YES, I AM. YOU'D HAVE TO ACTUALLY SEE WHAT I'M DOING AND THE APPLICATION WHICH I'M USING IT TO UNDERSTAND...

THANKS, THAT'S JUST WHAT I NEEDED. I COULDN'T FIND IT IN HELP. ALSO, IS THERE A WAY TO MAKE A DROP DOWN BOX THAT SHOWS 2 COLUMNS OF DATA, BUT (OBVIOUSLY) ONLY STORES 1? I KNOW YOU CAN DO THIS IN ACCESS....I'M JUST NOT SURE IF YOU CAN DO IT IN EXCEL OR NOT.

OK, let me do my best here to describe what I'm trying to do. I understand VBA coding in Access but not much in Excel. For what I'm trying to do on a whole Excel is a better venue for me to use. I have two worksheets in Excel and they are labeled as such: "Employee Evaluation Form" "Product...

So, I'm really confused now... You said I need to select the chart... I don't have a chart to select. Do you need to CREATE a chart FIRST of only 1 line of data before you can make one with two? I'll be working to scrounge up the columns of data that I want graphed against each other. In...

OK, it has been quite a while since I started this thread, and I haven't gotten around to solving my issue until now. When I go to Toos/Options/Chart - Plot VISIBLE cells only, I can't select ANYTHING because the entire top half of this tab is grayed out. I can only select the two check boxes...

OK, here's my scenario: I have a list of products that I want to graph. I only want to graph one product at a time. Each product has two categories, QA Audits % and Yields. QA Audits and Yields are collected daily. Ultimately I would like to graph the product with the date being the X-Axis...

OK, I finally got it! Get ready for this. This is what I did: My rank row is row 4. In row B12:K12 I used the equation given to me by Glenn: =-1000*B2+B3 and copied this across the whole row. In cell B14 I used a simple =COUNT(B2:K2) to see how many columns actually had data in them. In...

What do you mean about leaving blanks where data is not supplied? When data is not supplied, the form automatically makes the cell NULL (""). I have the form populated automatically. When I try what you proposed with 10 columns, it works fine. But if I use less than 10 columns, I get #Value...

OK, I've thought about this for a little bit and I think I have an idea of how to do this...but I need some assistance. In Row B16:K16, I have numbers 1-10 (ex: B16=1, C16=2, etc...). In Row B17:K17 I have the letters B-K. This is my thinking. I want to somehow manipulate the equation...

OK... Here is my last question for this thread. Now that I have the form working the way I want it to for 10 columns/people, I want to be able to modify it "on the run" so that it ranks the columns as my form changes. Glenn helped me set up my form so that I can use it as a front end...