Well, the idea is that sheet 1, cell A1 is E10, and that in sheet 2 column A SOME cell has E10 embedded in it.
Sheet 1, cell A2 is B20, and SOME cell in sheet 2, column A has B20 embedded in it.
So if it would be in A10, it should return value B10.
If it were A123, it would return B123 and so on.
Hi all,
I have a question regarding Vlookup, or maybe another feature i could us to search for a value in a cellrange.
Problem:
--------
In sheet 2 column A: i have cells containing text.
Ex. A1: Not pickled E10 instant devorced
A2: Foreseen in B30 always there
A3: ...
B1: P1114...
i'm aware that the code must work. If you check my last posting, you see that i did change the last lign in the code to the correct way.
To give you a little bit more information. The html page this code has to work on, is generated by a webfocus report. Webfocus is some sort of a reporting...
Still doesn't work somehow...
This is what i have now:
<form name="TDate">
<input size=20 maxlength=75 type='text' name='TodayDate' value=""></form>
<script language="JavaScript" type="text/javascript">
var date = new Date();
var d = date.getDate();
var day = (d < 10) ? '0' + d : d;
var m =...
i've tried to write a simple piece of code, that puts the current date into a textboxfield.
The current date should be written like this : 20062404
This is what i have so far:
<form name="Date">
<input size=20 maxlength=75 type='text' name='TodayDate' value=""></form>
<script...
Wow Dan, this does more then i would expect.
Thanks alot for your help, and again my excuses for my previous incomplete answers.
Thanks & have a great new year!
sorry for my answers.
This is what i post on my page in the <head> section
<script style="javascript/text" language="javascript">
var winW = 0, winH = 0;
if (parseInt(navigator.appVersion)>3) {
if (navigator.appName=="Netscape") {
winW = window.innerWidth-16;
winH =...
No, the idea is getting the screen size correct, but since i could find anything about this..
What i've done is just add this script in the header of the html.
Now you ask, maybe i should try to add it after the body tag...
i'm actually quiet a script-newbie. I've been searching the net for a fluid-kinda screen resize thing, but what i found was way over my head.
I'm currently using a script that chooses a background image depending on the users' screensize, and that works.
Now trying to reset my table to the...
I have found a script on the net that attaches a stylesheet to an .html document depending on the screen size of the user.
Exactly what i needed, but unfortunately, not working.
I've pasted it in the head of my html:
var winW = 0, winH = 0;
if (parseInt(navigator.appVersion)>3) {
if...
oki, i've tried it with the message in it Dan, but the message didn't show.
Maybe if i add the script that creates the cookie it might clear things up
The script that creates the cookie: right from within the html:
<script>
function saveCookie(name,value,days)
{
if (days)
{
var date =...
Hi all,
I have found this script on the net, and tried to impliment this to my project, but i can't seem to figure out why it's not working.
this script is set to check if OWC exists, and if so, what version. Depending on this info, it should display the related messagebox.
<script...
I checked everyting and the cookie is being made the right way.
It's a good idea to do the alert-thingy Dian.
But how do i put an alert in the function?
I've changed the last command as you suggested Dan, but the result remains the same.
It doesn't do anything when i click on "back".
It seems that the script is not activated somehow.
You have any idea why?
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.