Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup field question
I would like to use the lookup field but it only seems to give me a limited
number of columns to choose from is there a way to give me access to the full list of columns in a list? Also is there a way that I can use the lookup field with rules i.e. Column V=Y in list z where Column A=1009 Thanks -- Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup field question
In the standard VLOOKUP function you have access to any of the columns to the
right of the lookup range. If you want to see what's in column Z when you look up something in column A: =VLOOKUP(something,A1:Z1000,25,FALSE) for example. If you need to access columns to the LEFT, then you can use LOOKUP, or a combination of INDEX/MATCH Sorry, I don't understand your 2nd question. "Jeff" wrote: I would like to use the lookup field but it only seems to give me a limited number of columns to choose from is there a way to give me access to the full list of columns in a list? Also is there a way that I can use the lookup field with rules i.e. Column V=Y in list z where Column A=1009 Thanks -- Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Tab Name in Lookup Field | Excel Worksheet Functions | |||
Pivot Table Field Lookup | Excel Discussion (Misc queries) | |||
Lookup to find the last value based on name and date field | Excel Discussion (Misc queries) | |||
lookup field using two columns | Excel Worksheet Functions | |||
lookup field and copy the row across | Excel Worksheet Functions |