Dave The Spreadsheet Guy

I'm on a mission to help both Businesses and Individuals enhance their usage and experience of Microsoft Excel.

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@Patcole83 Wasn't the same without my running buddy!! Cheers @Patcole83 🤜💥🤛

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@newspacenewlife Getting into this speed flipping thing now ain't ya luv 😁 Farming later if ya fancy some 'seed' flipping 😂

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@DJDurnell Would that be Windows 95 or 98 @DJDurnell 🍔

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@Patcole83 @KODIECOLLINGS Man that's ugly!

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Now that's what I call a formula!! Great job @muddymuddymum

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum So glad the spreadsheet magic has worked out nicely for you 😍 Feel free to give us a shout if I can help with any more?

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum That's the one... jackpot 😁 There are many different ways to do things in Excel... that's the beauty of it. You're smashing it today 😍

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum If you'd prefer to use the IF formula, you'd need to nest the IF's within eachother, as per the pic attached? #AlwaysMoreThanOneWay ;-)

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Just gotten the VLOOKUP working at my end, as per pic, so definitely all about the formatting. The IF formula could work as well though, it will just be a massive formula... all about your preference though :-)

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Ahh sometimes the cell formatting can cause an issue? Can you ensure that both sets of codes are formatted as General and not Text?

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Perfect! So your VLOOKUP in the column F cell should look like this:

=VLOOKUP(column E cell ref i.e. E5, Sheet 1 table range from A3 to bottom right of table, 2, FALSE)

The 2 and the FALSE are as is. The previous two bits depend on cell references... hope that helps?

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Excellent stuff! In your table in sheet 1, is the code to the left of the description? If so, if you do a VLOOKUP in the cell in column F that looks up the column E value in the sheet1 table, that'll do it... just confused myself reading that back! Can ya send a pic of sheet 1?

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Love this 😍 Thanks ever so much!!

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Haha, if you've got a spare 10 mins, I created a YouTube video all about it 😉

https://t.co/9NKQ6T9QSm

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Cool. Do you have a full list of all codes and descriptions somewhere else in the spreadsheet? If not, could you build one? Then you could use a VLOOKUP to populate column F, using the code in column E, plus the reference list?

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Ahh the pleasure is all mine @muddymuddymum

Seeing people applying spreadsheets to solve real life tasks makes me happy 😍

Hope the rest of your day goes brilliantly and feel free to give us a shout if I can help any more?

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Fantastic stuff that is 😍 Proper glad you got it working the way you want it! Plus you got some exposure to SUMIF's and Dollar Signs... it's gonna be a great day for spreadsheets 😁

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Oh yes, it's all about the $ signs, or Absolute Referencing... everyone calls it the dollar signs thing though! You'll also want a dollar sign in front of the column reference i.e. $E$3 because columns and rows can be locked independently.

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum If you swap out the E:E and D:D, replacing them with $E:$E and $D:$D, that should lock them down nicely 👍 Hope your day of spreadsheet fun is going awesomely?

[Dave The Spreadsheet Guy @NiceSpreadsheet]

@muddymuddymum Haha, Techno God makes me sound like a German Club DJ jaaa? I'll happily be your Spreadsheet Guy though 😍