How to format spreadsheet questions.

[dandungan]

Hi Mr Excel,

I saw this format in the excel forum. How did this person get this format to work?

Dan

@ Sb, You mean this,

Excel 2007

	A	B	C
1	ColA	ColB	Result
2	1	60	-
3	2	61	-
4	3	62	-
5	4	63	-
6	5	64	-
7	6	65	-
8	7	66	-
9	8	67	-
10	9	68	-
11	10	69	69

Sheet2​

Worksheet Formulas Cell Formula C2 =IF(A2=10,VLOOKUP(A2,$A$1:$B$11,2,0),"-") C3 =IF(A3=10,VLOOKUP(A3,$A$1:$B$11,2,0),"-") C4 =IF(A4=10,VLOOKUP(A4,$A$1:$B$11,2,0),"-") C5 =IF(A5=10,VLOOKUP(A5,$A$1:$B$11,2,0),"-") C6 =IF(A6=10,VLOOKUP(A6,$A$1:$B$11,2,0),"-") C7 =IF(A7=10,VLOOKUP(A7,$A$1:$B$11,2,0),"-") C8 =IF(A8=10,VLOOKUP(A8,$A$1:$B$11,2,0),"-") C9 =IF(A9=10,VLOOKUP(A9,$A$1:$B$11,2,0),"-") C10 =IF(A10=10,VLOOKUP(A10,$A$1:$B$11,2,0),"-") C11 =IF(A11=10,VLOOKUP(A11,$A$1:$B$11,2,0),"-")

Muz.

 

[Sam_D_Ben]

Am sorry, this was wrong, check my second reply in that thread, that could be his requirement.


Muz.

 

[Smitty]

If you're referring to the image of the spreadsheet/formulas, you can use the Board's HTML Maker (you'll find a link in my sig).