Thread: table lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dksaluki dksaluki is offline
external usenet poster
 
Posts: 48
Default table lookup

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