Lookup with multiple results

[Max]

You're welcome, Bill !
Thanks for the feedback.

 

[Max]

What does "De nada" mean?

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------

De nada. Thanks for the kind words.

Alan Beban

 

[Gord Dibben]

Spanish for "it's nothing"

Gord

 

[Alan Beban]

It's one of a number of common Spanish colloquialisms roughly equivalent
to English "Don't mention it" or, perhaps closer, "It was nothing". Nada
in Spanish means "nothing".

Another is "No hay de que" (sometimes further shortened to "No
hay"--pronounced like "no I"), which is probably probably a shorthand
for something like "No hay nada de que decir gracias"--fairly literally,
"There is nothing for which to say thank you."

Basically, "You're welcome."

Alan Beban

What does "De nada" mean?

 

[Max]

Thanks, Gord !

 

[Max]

Thanks, Alan !
Was ignorant, now thoroughly enlightened <g>.

 

[Syed Ubaid]

This is the same question I have posted on 15/02/04.
Please inform me where I can download arrayFunction.xls
files. And anyother instruction to get the same result.

syed

Read the original instructions

=VLookups(123,A2:C5,2) array entered into a column of at least enough
cells to accommodate the output.

One cell, one result, multiple cells in a single column (array entered
Ctrl+Shift+Enter rather than just enter) - multiple results. If you expect
3 results, array enter in 3 cells.

 

[kydas]

Thank you for your great information. I have downloaded th
ArrayFunctions.xls and copy/pasted the module into my spreadsheet. M
spreadsheet now recognises vlookups. But I only receive a single reply
why?

For example - if I paste into c1 {=VLookups(12,A1:B5,2)} I only ge
100. I was expecting 100 101 104.

12 100
12 101
13 102
14 103
12 104

What have I missed?

KYDAS

 

[Frank Kabel]

Hi
have a look at Alan's site:
http://home.pacbell.net/beban
for downloading this file

 

[aimi]

Is there any way to do this dynamically