Thread: table lookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default table lookup

The function you need is MATCH.
--
David Biddulph


"dksaluki" wrote in message
...
Let's say i have a table. I can use MATCH() to know that I want to
look in column 13 for a certain value. Now I just need to figure out
what row a certain value is. For instance: 1810. Somewhere in
Column 13 is the value "1810"....I would like to find out what ROW
it's in. How can I tell Excel to look in Column 13 and find 1810, and
let me know what row it's in?

DK