LOOKUP Function

[T.J.S.]

First of all does the LOOKUP function have a limmit like
IF does? I am trying to like 400 different codes with 400
different names and it works for some of the codes but
the some of the codes come up with the wrong name or a
name repeated many times.

In my Spreadsheet I have a list of peoples names and
codes representing their names ex. Joe Shmoe = SMO164J,
The middle number is just a random number. I have a page
that has their code name and a 1 of 0 to determin if they
have paid yet. I have to find a way to take their code
from this page and find it on the page with their codes
and names and finally on the page that has if they have
paid or not print out the persons name.

Thanks for any help in resolving this

 

[Ken Wright]

Make sure you use the optional 4th argument of FALSE or 0, eg

=VLOOKUP(A1,MyTable,2,0)

This ensures that only an EXACT match is returned

 

[T.J.S.]

when I use the VLOOKUP if I put in anything for the third
(col_index_num) argument, I get the #REF error. Is ther
anyway I can get this to work with column E?

 

[Frank Kabel]

Hi
can you post your VLOOKUP formula. In the second parameter you have to
define a range which covers the column_index of the third parameter.
e.g.
=VLOOKUP(a1,'sheet1'!A1:B200,2,0)

 

[T.J.S.]

=VLOOKUP(A2,'Access - Participants'!B2:B401,5,0)

-----Original Message-----
Hi
can you post your VLOOKUP formula. In the second parameter you have to
define a range which covers the column_index of the third parameter.
e.g.
=VLOOKUP(a1,'sheet1'!A1:B200,2,0)

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Frank Kabel]

Hi
no wonder you get an error . Your lookup range consists only of
column B but you want to return the value form the 5th column. change
your fourmla to
=VLOOKUP(A2,'Access - Participants'!B2:F401,5,0)

If you want to return the value from column F

 

[Guest]

Thanks, That fixed my problem!

-----Original Message-----
Hi
no wonder you get an error . Your lookup range consists only of
column B but you want to return the value form the 5th column. change
your fourmla to
=VLOOKUP(A2,'Access - Participants'!B2:F401,5,0)

If you want to return the value from column F



--
Regards
Frank Kabel
Frankfurt, Germany



.