Help on edexcel spreadsheet please?:) x

Hi I might be able to help you but when I clicked on your link it just took me to the flickr sign in screen - I could not see the layout of your spreadsheet!

Are you able to upload your example spreadsheet to a post here (as an xls or xlsx attachment)?

Have you used VLOOKUP formulas before?

Ohh sorry about that..I'll upload a picture instead if that's okay. And no we haven't learnt that, my teacher is absolutely useless.-.- Thank you so so much for your help x

Hi, it looks from the picture that you're using Microsoft Works rather than Excel - is that correct?

I haven't actually used Works before although it looks like I have a copy installed on my laptop from ages ago - I'm hoping it works very similar to Excel!!

Does your file contain a Ratings table in it already?

Lol yes that's right but I just download excel cause it'll be much easier.Sorry about that,hope it's much more clearer now.

OK, so let's start with the 1st question - you need a VLOOKUP formula to bring back the Fuel Economy in column D for each rating code in column C of the first sheet.

In Excel you need to put a formula like this in cell D5:
=VLOOKUP(C5,Sheet2!$A$3B$6,2,FALSE)
You can then copy this formula into the cells below in the same column.

I suggest you have a look at the VLOOKUP function in the Excel help to see what it's doing - if you use the Insert Function facility it will actually insert a template for you and let you select the cells that go into the function.

Basically VLOOKUP takes 4 inputs: the thing you're looking up (e.g. the value "A" or the cell reference of that value like C5); the table where you get the values from (in this case range A3:B6 on the Sheet2 worksheet); the column containing the value you want (in this case column 2); and a value of FALSE (for an exact match) or TRUE (if you're trying to find a closest match in a range of sorted numbers).

Give this a go to start with in Excel and see if you can get it to work, then you can experiment a bit

Thank you,you're actually amazing!But the first formula says 'Error'?

My version of Excel (Excel 2007) doesn't seem to like your file very much - it keeps forcing me
to repair the file whenever I open it!! I don't know if this is removing anything that you have typed in, but the value showing in cell D5 is coming up as #VALUE! If this is what you meant, you can just type a formula over the top of it.

If you had some other error, can you save your file as a standard Excel file (xls or xlsx) - you should have a Save As option in Excel that will let you do this - before uploading it here?

Thanks

Yep I've got it! Thank you soo much for your help x