Dear all
Could you guy help me out with the VLOOKUP. below are the table i would like to use the VLOOKUP.
<tbody>
Num
AC
Name
Num
1
11002
ABC
1
Apple
How to vlookup Num and meet the criteria 42 of column AC then extract value of Name
1
11001
BCA
2
Orange
1
42001
Apple
3...