Model

Chat GTP 4

Example input

[Problem_Description]: I need to look up a value in Sheet1 Column A, and find the corresponding value in Sheet2 Column B. If it's not found, show "Not Available".

Example output

Here is the formula for your request:

=IFERROR(VLOOKUP(A2, Sheet2!A:B, 2, FALSE), "Not Available")

### Explanation:
1. **VLOOKUP(A2, ...)**: Looks for the value in cell A2.
2. **Sheet2!A:B**: Searches in the first two columns of Sheet2.
3. **2**: Returns the value from the 2nd column.
4. **FALSE**: Ensures an exact match.
5. **IFERROR**: Replaces error messages with "Not Available".