Thread: Excel Help - Lookups
View Single Post
Old 19-01-2007, 10:28   #2
gazzae
Inactive
 
gazzae's Avatar
 
Join Date: Jun 2003
Location: Belfast
Age: 46
Posts: 4,594
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
Re: Excel Help - Lookups
=INDEX(Sheet2!$A$1:$B$3, MATCH(H2,Sheet2!$A$1:$A$3,), MATCH("code",Sheet2!$A$1:$B$1,))

Where Sheet2!$A$1:$B$3 is where your lookup data us held
H2 is your town name and Code is the column you want to pull the values from.
gazzae is offline   Reply With Quote