我正在使用此公式从另一个工作表中获取信息。我想用宏来完成这个任务。
同时答案需要放在sheet2的B2单元格中央,字体大小为24。
=LOOKUP(Sheet1!F2,{"FL01","FL12","FL21","FL31","FL34"},{"ORLANDO PICKLIST","TAMPA PICKLIST","JAX PICKLIST","NAPLES PICKLIST","MIAMI PICKLIST"})
同时答案需要放在sheet2的B2单元格中央,字体大小为24。
谢谢
ThisWorkbook.Sheets("Sheet2").Range("B2").Formula = "=LOOKUP(Sheet1!F2,{" & """" & "FL01" & """" & ",FL12" & """ ",FL21" & """" & ",FL31" & """" & ",FL34" & """" & "},{" & """" & "ORLANDO PICKLIST" & """" & ",TAMPA PICKLIST" & """" & ",JAX PICKLIST" & """" & ",NAPLES PICKLIST" & """" & ",MIAMI PICKLIST" & """" & "})"
- Rahul Chawla