Qualification > Miscellaneous

Official Thread for AICT Doubts !

(1/8) > >>

The Golden Girl =D:
This is the "Official Thread for AICT Doubts" where you can post ALL your doubts from which ever board you're taking ;)

Make sure that you mention the following when posting your doubt :

1. The board you're taking.
2. The Year and the session e.g. June 2011.
3. The Paper e.g. Unit 1 for Edexcel.
4. The the number of Question you have doubt in.
5. If you can upload the paper in the "Additional Options" it would make it easier for others to answer.


Thank you.
SF Administration Team

Dibss:
CIE May June 09 P2 the practical
q 21 and 24
I used HLOOKUP
but then when I drag down to duplicate, the array changes as well :SSS
I've attached the excel sheet and the question paper.
Any help would be appreciated!

Malak:

--- Quote from: Dibss on September 22, 2011, 07:16:40 pm ---CIE May June 09 P2 the practical
q 21 and 24
I used HLOOKUP
but then when I drag down to duplicate, the array changes as well :SSS
I've attached the excel sheet and the question paper.
Any help would be appreciated!

--- End quote ---
I couldn't open your file for some reason  :-\
Anyway, here is my file attached. Check your formula with mine, i guess you didn't lock the array. I have used HLOOKUP and it works.

Dibss:
Thank you :) +rep
Your formula was:
=HLOOKUP(LEFT(B5,1),$B$1:$F$2,2,FALSE)
Mine was:
=HLOOKUP(MID(B5,1,1),B1:F2,2,FALSE)
So you're right the problem was with my array - how did you lock it? Did the $ sign come automatically? I selected the mini table cells I wanted to use, i'm guessing that's the wrong way?

Dibss:
One more question.
Do you know how to format cells into pounds for currency? All the PCs I've come across only seem to have the $ and euro option for currency fields (which is especially a problem for the access practicals :/).

Navigation

[0] Message Index

[#] Next page