QLD Whoretown...

[NismoGirl]

I dont have speakers at work so it wouldn't be as effective.

Now this stupid excel formula wont work

What does the $ sign in an excel formula mean again.

[Ska]

cya guys lata im going to get sum new tyres! 235/45/17 for the front. and the backs are ok. surprise!!!!

I'm getting new 235/45/17 sat $165 for Falken's ZE-326 But that is with the club discount through Bob Jane T-Marts.

[Ska]

I dont have speakers at work so it wouldn't be as effective.

Now this stupid excel formula wont work

What does the $ sign in an excel formula mean again.

ahhhhhh funny, soooo funny, must watch again!!

[NismoGirl]

Wheres my membership card punks?

[chaos]

money??

[Ska]

$ no idea, that's Marc's domain, and he's off pulling apart a printer that broke down, he is such a GOOD BOY!

[Ska]

Wheres my membership card punks?

Dirks got the cards hasnt he? I'll be driving to his house tonight to pick up the bob jane discount card as i'll need it saturday

[chaos]

ska found a new pet

[Ska]

Just asked the guru, $ means it is an unchangable cell reference

[chaos]

just walked into my room, its 15 degrees hotter than what it is in the lounge room

[Revhead]

The dollar sign before a part of the cell reference makes that part of the reference static, ie if you move/change the cell containing the formula, that part of the formula isn't modified. If you have $A5, then copy it one cell down and right, the ref will change to $A6 - there is no $ sign in front of the row number, so it's allowed to change. Doing the same thing with A$5 will allow the A to change, so it'll change to B$5. I'm not the best at explaining things, but if you want to email the document to me I'm happy to look at it

[Ska]

The server room is about 2 degrees hotter than my office, which is a nice 22 degrees

[NismoGirl]

I thought it was the reference point.

Can you decipher this formula for me?

=VLOOKUP(B63,'[26_261204.xls]MAIN SHEET'!$A$4:$S$93,19,FALSE)

[NismoGirl]

ARGH! Cyrus! Get Marc back!

Or gimme his email

[Ska]

huh :confused:

[Ska]

He's in the middle of typing this HUGE reply

[Ska]

BBHAH ahAh HAh AHh A HHAH HA HAH hAHhHAHHAhaH AHAHhaHA H haHAH HA aaaa!!!

:D

[Revhead]

VLOOKUP is used to look up a value in the leftmost column of a table, then returns a value from the same row.

So, your formula is looking for a value (whatever is in B63 of the current sheet, eg 'fred') in the leftmost column of the area between A4 and S93 on the sheet named 'main sheet' in the file '26_261204.xls'. When it finds 'fred' in this column, it returns the value in column 19 (ie column S) of that row. The 'FALSE' at the end specifies that it must be an EXACT match, rather than an approximate one.

[85URK]

got a set of nankang 235/45/17 for $130 dont know how good they are but they look like a good pattern

[NismoGirl]

OMG your so smart.

Sorry I had to ask my boss. I didnt want to have to but I did. The formula was right and it was looking up what it needed to in the right sections.. but while I was on leave last week one of the ladies that was doing my work changed the name of one of the guys in one of the databases so what I was telling it to look up, it couldn't find cause it was spelt different in the two databases.

It was only one entry that was stuffing up, all the rest were fine!

Thanks heaps marc. I actually understand the formula now. My boss just showed me and said "heres how you copy it across" Didn't actually tell me what it does and what it's doing.