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"...
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...
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...
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...
I have a workbook that has 7 sheets. One sheet has approx. 1000 lines/rows of data. My users may select one row or 100 rows. Instead of printing out every page I would like to be able to send the rows selected either to a new sheet or an existing sheet.
I have an existing work book that has a formula that I can't seem to find anywhere. The work book has 5 sheets.
The formula is "=multiplier(D61)". It is the "multiplier" that I can't find. The multiplier changes dependant on the value of another cell. I would like to change the value of the...
I'm trying to connect to a server via ftp with no luck. The server is running xp-pro sp2 with iis installed. I have enabled the firewall with exceptions for ports 20 and 21. I have also disable the Mcafee Personal firewall. The router is a linksys WRV54G and I have disabled its firewall and am...
I have a user running Win XP with Outlook 2003 and is setup with 3 seperate profiles. The first 2 profiles are on the same domain just different pst folder, the 3rd is on a completely different domain and has a seperate pst folder. The problem is when he creates a new e-mail message from 1 of...
I have a Redhat 7.3 server, it was working fine but I decided to install webmin. The install went fine and I can now remotely manage the server. The problem is that when I reboot the server either through webmin or at the console the server reboots fine but the GUI on the server seems to hang...
We are planning to install MDaemon as our new e-mail server. We want to test it on a few users before we switch every body over. We have only 1 mx record and 1 domain name. Is there a way we can have the test user keep their existing mail address xxxxx.xxxx@domain.com but have thier E-mails go...
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.