The LOOKUP function has two syntax forms:
- AVector and Array
- BAND and OR
- CTRUE and FALSE
- DIF and BLANK
Solution & Step-by-step Explanation
In modern spreadsheet tools (like MS Excel and Google Sheets), the LOOKUP data function can be utilized in either of two standard layout syntax configurations: the Vector form or the Array form.