# Search:

Page 1 of 13 1

1. ## Thread: Conditional Lookup based on two values

Replies
7
Views
1,908

### There are several possibilities of IF with And,...

There are several possibilities of IF with And, Match & Index or Sumproduct. Can you attach a copy with sensitive data removed.
2. ## Thread: Text LookUp More Than One Condition

Replies
3
Views
711

### try this array formula in C3 (confirm with Ctrl +...

try this array formula in C3 (confirm with Ctrl + Shift + Enter)

=INDEX(\$C\$10:\$C\$15,MATCH(1,(\$A\$10:\$A\$15=A3)*(\$B\$10:\$B\$15=B3),0))
3. ## Thread: Logical Function with Vlookup

Replies
95
Views
4,413

### One possible workaround is to check it for "N/A"....

One possible workaround is to check it for "N/A". Try this :
...
4. ## Thread: Logical Function with Vlookup

Replies
95
Views
4,413

### One possible workaround is to check it for "N/A"....

One possible workaround is to check it for "N/A". Try this :
...
5. ## Thread: Logical Function with Vlookup

Replies
95
Views
4,413

### One possible workaround is to check it for "N/A"....

One possible workaround is to check it for "N/A". Try this :
...
6. ## Thread: Logical Function with Vlookup

Replies
95
Views
4,413

### One possible workaround is to check it for "N/A"....

One possible workaround is to check it for "N/A". Try this :
...
7. ## Thread: Logical Function with Vlookup

Replies
95
Views
4,413

### One possible workaround is to check it for "N/A"....

One possible workaround is to check it for "N/A". Try this :
...
8. ## Thread: Logical Function with Vlookup

Replies
95
Views
4,413

### One possible workaround is to check it for "N/A"....

One possible workaround is to check it for "N/A". Try this :
...
9. ## Thread: Logical Function with Vlookup

Replies
95
Views
4,413

### One possible workaround is to check it for "N/A"....

One possible workaround is to check it for "N/A". Try this :
...
10. ## Thread: Logical Function with Vlookup

Replies
95
Views
4,413

### One possible workaround is to check it for "N/A"....

One possible workaround is to check it for "N/A". Try this :
...
11. ## Thread: Cell show formula not result

Replies
6
Views
5,276

### It converts the inputs in to plain text. can...

It converts the inputs in to plain text. can viewed in formula bar.

in addition, holding down ~with Ctrl key shows formula itself instead of results and vice versa.

Replies
2
Views
703

### Thanks, much appreciated.

Thanks, much appreciated.

Replies
9
Views
1,068

### stuck... installed .Net Framework, installed...

stuck...

installed .Net Framework, installed the PW cracker & it took a whole day on a XP machine without any result.http://windowssecrets.com/forums/images/smilies/angry.gif
14. ## Thread: Filling a cell from one worksheet to another

Replies
5
Views
703

### A little more explanation with stripped down...

A little more explanation with stripped down copy, if possible, is required to know what exactly you are looking for.
15. ## Thread: A Tribute To Hans

Replies
103
Views
13,713

### Edited :I thought not to post any further...

Edited :I thought not to post any further comments < to retain the purpose of thread> but..

It is not anger actually. It shows how we are loosing our sensibility (while we love everything that...

Replies
7
Views
1,422

17. ## Thread: Cell reference problem (EXcel 2003 SP3)

Replies
7
Views
1,422

### I would prefer to let the excel perform the task...

I would prefer to let the excel perform the task its own way. Not responding message appears on interruption only.

BTW, are you trying to replace the contents for all the ws's in one go?

Replies
21
Views
2,156

### and definitely, you cant tell how long should I...

and definitely, you cant tell how long should I wait to attain 'that age'.

can you?
19. ## Thread: Responses and Indications

Replies
20
Views
2,412

### Already posted here (http://bro.ws/768702L) a...

Already posted here a couple of month ago.

Replies
21
Views
2,156

### hmmmmmm:huh: BTW, what is that 'certain...

hmmmmmm:huh:

BTW, what is that 'certain age'http://windowssecrets.com/forums/images/smilies/sad.gif

Replies
21
Views
2,156

### Leif, What it is all...

apologies if I mis-understood , but....

Replies
8
Views
1,014

23. ## Thread: Formula to extract last filtered item

Replies
5
Views
892

### Since there are only 2 character in your data, I...

Since there are only 2 character in your data, I use "Z" to make excel understand to look this first & if not found, put the last value from the range.
24. ## Thread: A Tribute To Hans

Replies
103
Views
13,713

### 25000 + old lounge member & less then 50 thanks...

25000 + old lounge member & less then 50 thanks note.http://windowssecrets.com/forums/images/smilies/angry.gif

It seems that there is some other way (which I am not aware about) to pay gratitude...