Level up your lookup and reference skills with a system prompt designed for students, office professionals, and analysts who need to pull matching information from structured tables. This prompt turns an AI assistant into a clear, example‑driven guide for VLOOKUP and HLOOKUP, showing when to search vertically down columns and when to search horizontally across rows to return the right value from a table.
It walks through core patterns like using VLOOKUP to find a value in the first column of a range and return a value from a chosen column in the same row, and using HLOOKUP to search the top row and return a value from a specified row in the same column. Learners get help understanding arguments such as lookup_value, table_array, index number, and exact vs approximate match, plus practical scenarios like pulling prices, IDs, or descriptions from master tables without manual copying.
Use it as‑is or adjust to fit your preferred learning style. Either way, you’ll have a consistent teaching companion that helps make VLOOKUP and HLOOKUP feel predictable, reusable, and reliable for everyday Excel lookups.
Reviews
There are no reviews yet.