The user is requiring the following output:
1)Trades that are reportable
2)Trades that are non Reportable
3)Any N/A’s that come in the result (which would mean we need to update the Codes in sheet2)
The formula should be based on the following:
Obtained from the OzGrid Help Forum.
Solution provided by AliGW.
|How to maintain the VLOOKUP font format|
|How to insert VLOOKUP into cell with variable array|
|How to use VLOOKUP (example)|
|How to use the VLOOKUP formula|