Excel VLOOKUP questioni
Thread Starter
Burning Brakes
Joined: Jan 2001
Posts: 947
Likes: 0
From: New York
Excel VLOOKUP questioni
You know in Excel, VLOOKUP defined as:
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)
so you can have some like:
VLOOKUP("blah", A10:B20, 2, 0)
then I have seen something like this:
VLOOKUP("blah", MyLookupTable, 2, 0)
Does anyone know how to define the reference MyLookupTable to a range of table cells?
Thanks.
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)
so you can have some like:
VLOOKUP("blah", A10:B20, 2, 0)
then I have seen something like this:
VLOOKUP("blah", MyLookupTable, 2, 0)
Does anyone know how to define the reference MyLookupTable to a range of table cells?
Thanks.
Thread
Thread Starter
Forum
Replies
Last Post
08_UA7_Gr33k
Member Cars for Sale
13
Feb 11, 2016 02:17 PM
InFaMouSLink
Car Parts for Sale
6
Oct 27, 2015 06:52 PM
08_UA7_Gr33k
Member Cars for Sale
1
Sep 27, 2015 01:56 PM