Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
table lookup
On Sun, 9 May 2010 11:33:41 -0700 (PDT), dksaluki
wrote: 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 Column 13 is normally refered to as column M. Try this formula: =MATCH(1810,M:M,0) Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table lookup | Excel Discussion (Misc queries) | |||
Lookup Table | Excel Discussion (Misc queries) | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Help with lookup table | Excel Worksheet Functions |