Lookup function?
Perfect! Thanks to both of you!
"PatrickA" wrote:
You're on the right track. Have you tried VLOOKUP and HLOOKUP?
Lookup functions can help you find and return related records. When
you use a lookup function, you're essentially saying, "Here's a value.
Go to another location, find a match for my value, and then show me
the words or numbers that are in a cell next to that matching value."
If it helps, you can think of that third value as your search result.
In the function names
V stands for vertical - use VLOOKUP when you need to search up and
down through one or more columns.
H stands for horizontal. - use HLOOKUP when you need to search across
through one or more rows of information.
Here's a sample formula
=VLOOKUP(G3,$A$4:$B$41,2,FALSE)
=VLOOKUP means Search through one or more columns of data
G3 means Use the value in G3 as your search term
$A$4:$B$41 means Search through cells A4 to B41 for a match to the
value in cell G3.
2 means and when you find a match, return the value in
column 2
FALSE means but only for an EXACT match.
Note: The $ symbols in $A$4 keep the row and column addresses from
changing when you copy the formula from cell to cell.
Hope this helps,
Patrick
|