Tengo una tabla dinamica y no se como hacer una busqueda con la función
BUSCARV, para que dando yo dos comandos me de el resultado.


I have a list and I don't know how to search for a result by using FINDV and
givin two commands instead of one!

PLEASE HELP!

Hi Ger,

Perahaps, rather than VLookup(BUSCARV) you could use a combimation of the
Index (INDICE) and Match (COINCIDIR) functions.

See, for example, a solution recently posted by Bob Phillips to a similar
question:

http://tinyurl.com/aaen9

In his response, Bob suggests a formula :

=INDEX(C1:C100,MATCH(M1&M2,A1:A100&B1:B100,0))

In your Spanish version, this formula equates to:

=INDICE(C1:C100;COINCIDIR(M1&M2;A1:*A100&B1:B100;0 ))

where M1 and M2 are two lookup values.


Possibly you could adapt this to your situation.


---
Regards,
Norman



"Ger" wrote in message
...
Tengo una tabla dinamica y no se como hacer una busqueda con la función
BUSCARV, para que dando yo dos comandos me de el resultado.


I have a list and I don't know how to search for a result by using FINDV
and
givin two commands instead of one!

PLEASE HELP!

Norman,

translateIT working ok for you?
<VBG

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Norman Jones wrote :

Hi Ger,

Perahaps, rather than VLookup(BUSCARV) you could use a combimation of
the Index (INDICE) and Match (COINCIDIR) functions.

See, for example, a solution recently posted by Bob Phillips to a
similar question:

http://tinyurl.com/aaen9

In his response, Bob suggests a formula :

=INDEX(C1:C100,MATCH(M1&M2,A1:A100&B1:B100,0))

In your Spanish version, this formula equates to:

=INDICE(C1:C100;COINCIDIR(M1&M2;A1:*A100&B1:B100;0 ))

where M1 and M2 are two lookup values.


Possibly you could adapt this to your situation.


---
Regards,
Norman



"Ger" wrote in message
...
Tengo una tabla dinamica y no se como hacer una busqueda con la
función BUSCARV, para que dando yo dos comandos me de el resultado.


I have a list and I don't know how to search for a result by using
FINDV and givin two commands instead of one!

PLEASE HELP!

Hi KeepITcool,

Yes, indeed - as per my private email many moons ago!



---
Regards,
Norman



"keepITcool" wrote in message
.com...
Norman,

translateIT working ok for you?
<VBG

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Norman Jones wrote :

Hi Ger,

Perahaps, rather than VLookup(BUSCARV) you could use a combimation of
the Index (INDICE) and Match (COINCIDIR) functions.

See, for example, a solution recently posted by Bob Phillips to a
similar question:

http://tinyurl.com/aaen9

In his response, Bob suggests a formula :

=INDEX(C1:C100,MATCH(M1&M2,A1:A100&B1:B100,0))

In your Spanish version, this formula equates to:

=INDICE(C1:C100;COINCIDIR(M1&M2;A1:*A100&B1:B100;0 ))

where M1 and M2 are two lookup values.


Possibly you could adapt this to your situation.


---
Regards,
Norman



"Ger" wrote in message
...
Tengo una tabla dinamica y no se como hacer una busqueda con la
función BUSCARV, para que dando yo dos comandos me de el resultado.


I have a list and I don't know how to search for a result by using
FINDV and givin two commands instead of one!

PLEASE HELP!