Type Blancer Tool

[miau]

spreedsheet i pick a type and get n/a all over

The .xls or the .ods? I haven't been able to test the .xls one because I don't actually have Excel, unfortunately.

.xls

[TwistedLogic]

.xls

Alright, I think I found the issue, but I can't test it in OpenOffice. I've uploaded the new file; could you please take a look for me?

[miau]

.xls

Alright, I think I found the issue, but I can't test it in OpenOffice. I've uploaded the new file; could you please take a look for me?

still not working

[TwistedLogic]

still not working

For some reason OpenOffice is deleting my formula when I save it.

The formula should be:

=INDEX(Sheet2!$C$2:$T$20,MATCH($A3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))*INDEX(Sheet2!$C$2:$T$20,MATCH($B3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))

In case you don't have much experience with Excel, paste that into C3, then drag it to T3, then drag all of that down to row 8.

[miau]

still not working

For some reason OpenOffice is deleting my formula when I save it.

The formula should be:

=INDEX(Sheet2!$C$2:$T$20,MATCH($A3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))*INDEX(Sheet2!$C$2:$T$20,MATCH($B3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))

In case you don't have much experience with Excel, paste that into C3, then drag it to T3, then drag all of that down to row 8.

thank you

[TwistedLogic]

No problem. I'll go ahead and put a notice in the OP.