Lookup field question

[Jeff]

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

 

[Bob Umlas, Excel MVP]

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.