Excel Lookup Function
=IF(E5="","",VLOOKUP(E5,A:B,2,FALSE))
E5 – Query Field
A:B – Column A & Column B All Rows
2 – 2 x Column(s)
Excel Lookup Function
=IF(E5="","",VLOOKUP(E5,A:B,2,FALSE))
E5 – Query Field
A:B – Column A & Column B All Rows
2 – 2 x Column(s)
馬仔驚自己唔記得要留既notes 