EXCEL列B中根据VLOOKUP出的数据将1替换成男，2替换成女，3替换成未知。怎么写

Question

=substitute((VLOOKUP(J2,[工作薄1.xls]RequestForm!$B:$G,6,0))E,"1","男"，E,"2","女"，E,"3","未知")
上面我这样写是错的。请大神指教

Answer 1

公式修改如下：
=substitute(substitute(substitute((VLOOKUP(J2,[工作薄1.xls]RequestForm!$B:$G,6,0)),"1","男"),"2","女"),"3","未知")