Prompt Details

ModelChat GTP 4Example 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".

Preview Output Generated by This Prompt

Category:

Business

Advertising

Finance

Content

Tags:

Data analytics

Data

Google

Excel & Google Sheets Genius - Formula Bot | GPT Prompt

Name: Excel & Google Sheets Genius - Formula Bot
Brand: LaPrompt
SKU: 72oS0Bb8
Price: 2.99 USD
Availability: InStock
Author: user_7193111c388447ec

Text prompt for Chat GTP 4, 136 words, no artist name used, instructions with ready-to-use prompt examples included.

$2.99 USD

Stop struggling with spreadsheets. Instantly generate complex Excel & Google Sheets formulas, Macros, and VBA scripts. Perfect for Accounting, HR, and Data Analysis.

High-quality consistent results - tested & verified by LaPrompt
This digital product available immediately after payment
Prompt page with instructions opens automatically after purchase
To be able to use the prompt, you already need access to GPT

25.01.2026 6

QuantCode Lab

Rank: 140Sales: 0

🚀 Start selling your own prompts

Business generated with GPT prompt

Advertising generated with GPT prompt

Finance generated with GPT prompt

Content generated with GPT prompt

Data analytics generated with GPT prompt

Data generated with GPT prompt

Google generated with GPT prompt