# Search:

Type: Posts; User: Bob Phillips; Keyword(s):

1. ## Thread: Forgot Formula, and can't find it

by Bob Phillips
Replies
2
Views
564

### Just use =A1*A2 with a custom format of...

Just use

=A1*A2

with a custom format of \$#,##0.00"ea"
2. ## Thread: █ Automatically transferring data between worksheets █

by Bob Phillips
Replies
2
Views
9,824

### Use this formula in TeacherView ...

Use this formula in TeacherView

=IF(ISNA(MATCH(\$A3,'Class view'!B\$2:B\$11,0)),"",INDEX('Class view'!\$A\$2:\$A\$11,MATCH(\$A3,'Class view'!B\$2:B\$11,0)))
3. ## Thread: Pasting a volatile formula in Excel 2007

by Bob Phillips
Replies
4
Views
2,066

### Shouldn't you refer to a single cell, not the...

Shouldn't you refer to a single cell, not the whole column

=VLOOKUP(OFFSET(F2,0,-2),'Lookup current policies.xlsx'!ExpiryDates,2,0)
4. ## Thread: Some design ideas please

by Bob Phillips
Replies
2
Views
756

### You can't divide a cell or pair of cells...

You can't divide a cell or pair of cells diagonally, but you could overlay a triangular shape with a high transparency factor. But I have to ask what is your objective. Having a value in one of the...
5. ## Thread: formula help

by Bob Phillips
Replies
20
Views
1,788

### The real requirements are slowly seeping out, I...

The real requirements are slowly seeping out, I bet we haven't got them all yet.

Try this

=IF(AND(D3=H3,ISNUMBER(MATCH(E3,\$I3:\$O3,0))),INDEX(\$I\$2:\$O\$2,1,MATCH(E3,\$I3:\$O3,0)),"")
6. ## Thread: formula help

by Bob Phillips
Replies
20
Views
1,788

### Try this array formula ...

Try this array formula

=IF(ISERROR(MATCH(D3,\$H\$3:\$H\$7,0)),"",MIN(IF(\$I3:\$O3<>"",\$I\$2:\$O\$2)))
7. ## Thread: formula help

by Bob Phillips
Replies
20
Views
1,788

### That is what my formula does.

That is what my formula does.
8. ## Thread: formula help

by Bob Phillips
Replies
20
Views
1,788

### Try =INDEX(\$I\$2:\$O\$2,MATCH(\$E3,\$I3:\$O3,0))

Try

=INDEX(\$I\$2:\$O\$2,MATCH(\$E3,\$I3:\$O3,0))
Results 1 to 8 of 8