VLOOKUP source values are a formula result. Getting #N/A
glad to help, merci pour le retour!
--
isabelle
Le 2012-01-24 19:41, Pete a écrit :
We like shopping here. Thank you isabelle. Merci beaucoup!
Pierre
On Jan 24, 5:52 pm, wrote:
hi PeTe,
on sheet table
A B
---------------
0 BLK
1 BRN
=INDEX(table!B:B,MATCH(B2,table!A:A,0))&" /"&INDEX(table!B:B,MATCH(C2,table!A:A,0))
--
isabelle
|