LOOKUP Function

  • Thread starter Thread starter T.J.S.
  • Start date Start date
T

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
 
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
 
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?
 
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)
 
=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



.
Click to expand...
 
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
 
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



.
Click to expand...
 
Back
Top