Excel VlookUp prob

  • Thread starter Thread starter ristanto
  • Start date Start date
R

ristanto

hi guys
i am doing 3 search fields. 1 for ID , 1 for Name and 1 for Yea
Joined.

the function for ID works. it returns me the values of it
-> =IF(ISNA(VLOOKUP(ID,Datas,3,FALSE)),"No Suc
User",VLOOKUP(ID,Datas,3,FALSE))

but when i tried it for Name n Year. It doesnt work although i hav
made all the neccesary changes. Why is this so?
Please help me . Thanks for all ur repl
 
hi
you're not really provided enough information to tell, but at a guess - the
thing you're looking up must always be the left most column of the table
that you're looking up in
i.e. ID must match the data in the leftmost column of Datas
and Name must match the data in the leftmost column of whatever table you're
looking up in etc

if this doesn't help could you please provide additional details - like the
formulas you've tried for Name and Year and what the columns in the lookup
table(s) are.

Regards
JulieD
 
oic .. the column have to be at the left hand side ?.. so is there lik
any other methods which i can use to get wat i want.. is there anywa
to gather data from columns not on the left side?


My ID is on the most left.

For iD:

=IF(ISNA(VLOOKUP(ID,Datas,8,FALSE)),"No Suc
User",VLOOKUP(ID,Datas,8,FALSE))

For name: =IF(ISNA(VLOOKUP(haha,Datas,8,FALSE)),"No Suc
User",VLOOKUP(haha,Datas,8,FALSE))

can u guys teach me how to get data from the other columns? Thx for u
above help to
 
Hi
use a combination of INDEX / MATCH.
Though in your case if you only want to test for existence
you may use one of the following:
1.
=IF(ISNA(MATCH(value,range_to_check,0)),"not
found","Found")

2.
=IF(COUNTIF(range_to_check,value),"Found","Not Found")
 
Just to be more specific abit

ID Name Education Year
1 A degree 2000
2 B Bachelor 2001
3 C Diploma 1999


Lets say this is any example of my database. I can extract the detail
using ID.

E.G Enter Your ID ( 1 )
Name ( A )
Education ( deg )
Year ( 2000 )

if i wan to do a search by Name too. is it possible?
showing the Id, education and year.
 
Hi
if you want to search for the name and get the ID try
=INDEX(A1:A100,MATCH(ID_value,B1:B100,0))
 
If your "Datas" table is A1:D4, with the ID column on the left, then that
works fine for your VLOOKUP on Id.

For your VLOOKUP on Name, use range B1:D4.
 
Back
Top