View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default 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