Jump to content
SAU Community

Recommended Posts

  • Replies 62.7k
  • Created
  • Last Reply

Top Posters In This Topic

  • chaos

    7164

  • Ska

    5791

  • BelGarion

    3645

  • Nexus9

    3590

Top Posters In This Topic

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 :D But that is with the club discount through Bob Jane T-Marts.

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

Now this stupid excel formula wont work :D

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

ahhhhhh funny, soooo funny, must watch again!! :D

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 :D

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.

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.

Guest
This topic is now closed to further replies.



  • Similar Content

  • Latest Posts

    • Hey everyone. Is there a way I can get the original window sticker (maroney label) for my 1995 R33 GTST? I doubt I’ll be able to ever get it but it’s worth a shot to ask
    • Have a vb in honour of the car comming back
    • It was a great, but typical track day, and some VB was ingested at the night time debrief 🤪
    • And so, to round this out, I couldn't be happier to confirm @MBS206 has decided to buy the car. He drove down from sunny QLD with a trailer last week and it is off to its new home today. I'll let Matt confirm on next steps but I understand broadly that the plan is to leave it pretty much as is, and just get some quality wheel time with a nicely balanced car that is pretty much track ready. There are a few a jobs still to be done first but nothing too major and I think its a very smart buy Dinner last night at the Paragon with a round of VBs (mostly) for Neil
    • Well, 50 pages and the end of a chapter for this car. We took it out for a shakedown at Wakie yesterday, and everything went well. There were a couple of niggles: - Oil cooler fitting leak - tightened, cleaned, stopped leaking - Radiator cap overflow fitting was leaking....Mark called it, the overflow fitting was threaded in and not tight....tightened, tested and held pressure - Small oil leak at the rear of the block, probably the turbo oil feed - too hot to get at it comfortably but probably just needs to be nipped up - leak at the driver's side rear brake line where it meets the hardline. Fitting wasn't loose, so Matt backed it off and back on, no further leaks - there's also a leak somewhere on the top of the fuel tank, maybe that cross over fuel line - that was has been left to fix when its on a hoist Otherwise than those niggles the car went great, turned great and stopped great so it was a very successful day out. I'm always really nervous when a car first hits the track after a long break, especially with a brand new engine as well but it was great. VID-20251011-WA0007.mp4  Big thanks to @The Bogan who dropped by and helped out, @MBS206 and my nephew Lachlan the apprentice.  Neil's wife Mel also surprised the hell out of all of us by dropping by; she's up in Tamworth these days but was travelling to Melbourne so had plausible deniability for turning up at the garage, it was great to see her but also obviously a bit sad all round.
×
×
  • Create New...