# Search:

Type: Posts; User: prasad; Keyword(s):

Page 1 of 13 1

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

by prasad
Replies
7
Views
1,778

### 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

by prasad
Replies
3
Views
673

### 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

by prasad
Replies
95
Views
4,263

### 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

by prasad
Replies
95
Views
4,263

### 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

by prasad
Replies
95
Views
4,263

### 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

by prasad
Replies
95
Views
4,263

### 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

by prasad
Replies
95
Views
4,263

### 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

by prasad
Replies
95
Views
4,263

### 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

by prasad
Replies
95
Views
4,263

### 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

by prasad
Replies
95
Views
4,263

### 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

by prasad
Replies
6
Views
4,996

### 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.
12. ## Thread: New Posts

by prasad
Replies
2
Views
660

### Thanks, much appreciated.

Thanks, much appreciated.
13. ## Thread: Password protected files

by prasad
Replies
9
Views
1,016

### 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

by prasad
Replies
5
Views
663

### 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

by prasad
Replies
103
Views
13,277

### 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...
16. ## Thread: Cell reference problem (EXcel 2003 SP3)

by prasad
Replies
7
Views
1,367

### See if this...

See if this could help you.
17. ## Thread: Cell reference problem (EXcel 2003 SP3)

by prasad
Replies
7
Views
1,367

### 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?
18. ## Thread: Shocking Laptop

by prasad
Replies
21
Views
2,099

### 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

by prasad
Replies
20
Views
2,322

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

Already posted here a couple of month ago.
20. ## Thread: Shocking Laptop

by prasad
Replies
21
Views
2,099

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

hmmmmmm:huh:

BTW, what is that 'certain age'http://windowssecrets.com/forums/images/smilies/sad.gif
21. ## Thread: Shocking Laptop

by prasad
Replies
21
Views
2,099

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

Leif, What it is all about?http://windowssecrets.com/forums/images/smilies/sad.gif

apologies if I mis-understood , but....
22. ## Thread: Edit Title

by prasad
Replies
8
Views
955

### and it is already done in this thread...

and it is already done in this thread, I think http://windowssecrets.com/forums/images/smilies/evilgrin.gif
23. ## Thread: Formula to extract last filtered item

by prasad
Replies
5
Views
829

### 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

by prasad
Replies
103
Views
13,277

### 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...
25. ## Thread: Formula to extract last filtered item

by prasad
Replies
5
Views
829

### You probably need a code to place the input...

You probably need a code to place the input directly in H159
OR
=LOOKUP("Z",C8:C65536) in H159 will return the last value from the specified range.
Results 1 to 25 of 314
Page 1 of 13 1