[Badion]

Hello guys, really need help.
My teacher sent me to email that past paper 3 2008 but I'm stuck!!!
I can't move from the first question which is about stuff with Excel and function("lookup&quot
I've attached all files that he sent to me please guys someone explain me how to do it, my exam is on Tuesday(((
Thanx to everyone...

[Badion]

Please people only first question someone help!!!!!

[Siddd]

Could you post the number of the task?

[Badion]

It starts:

2 In the Department column use a lookup function to show the department name.
Use the Dcode column for the lookup value and the file J8CODE.CSV for the
array. Make sure that you use both absolute and relative referencing within your
function.
Replicate this function so that the department name for each of the 7 items is
shown.

So it is task N2

[Badion]

Actually I have one more question, look at the image, everything is stiked to each other, how can change it?))

[Siddd]

Originally Posted by Badion

Actually I have one more question, look at the image, everything is stiked to each other, how can change it?))

I have the same problem with loading CSV files. However, it works at school so it's most probably a Vista thing

[Siddd]

Originally Posted by Badion

It starts:

So it is task N2

Not quite sure, but try clicking on the lookup function option. Choose the external file as your array (omitting the field titles)

[Badion]

Originally Posted by Siddd

I have the same problem with loading CSV files. However, it works at school so it's most probably a Vista thing

Ok, thanx it is might be the reason))))

[ajayhp]

vista sucks, u guys should stay with xp. downgrade

[saleemahmedfaruqi]

[It so simple I can do it i done it before

[saleemahmedfaruqi]

i got a problem and where do i get a file of J8CODE.CSV