Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
HI,for some reason it doesnt work for me today.
TABLE example: Acc type 73010 ADMIN Travel cost 74000 ADMIN the other is: Trx Date Acc # Acc name 01/04/2006 73010-100-CAN-000 Customer DL - Canada#N/A 28/04/2006 74000-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A Using the formula =VLOOKUP(LEFT(B78,5),ADMIN!$A$1:$B$32,2,FALSE) I get #N/A Wot am i doing wrong? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
You get #N/A when using VLOOKUP is the sought value is not present in
the table - perhaps you might need to add some more codes, or check that you don't have spaces etc at the end of them. Hope this helps. Pete On Apr 17, 9:54 am, Joe wrote: HI,for some reason it doesnt work for me today. TABLE example: Acc type 73010 ADMIN Travel cost 74000 ADMIN the other is: Trx Date Acc # Acc name 01/04/2006 73010-100-CAN-000 Customer DL - Canada#N/A 28/04/2006 74000-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A Using the formula =VLOOKUP(LEFT(B78,5),ADMIN!$A$1:$B$32,2,FALSE) I get #N/A Wot am i doing wrong? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
thanks, that is not the problem. is like the formula doesnt read the number
right. Maybe diff format??? how can i change this? thks "Joe" wrote: HI,for some reason it doesnt work for me today. TABLE example: Acc type 73010 ADMIN Travel cost 74000 ADMIN the other is: Trx Date Acc # Acc name 01/04/2006 73010-100-CAN-000 Customer DL - Canada#N/A 28/04/2006 74000-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A Using the formula =VLOOKUP(LEFT(B78,5),ADMIN!$A$1:$B$32,2,FALSE) I get #N/A Wot am i doing wrong? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
Is there anything that I might be doing wrong that affects the way Vlookup
picks up the numbers? Ie number or text format "Joe" wrote: thanks, that is not the problem. is like the formula doesnt read the number right. Maybe diff format??? how can i change this? thks "Joe" wrote: HI,for some reason it doesnt work for me today. TABLE example: Acc type 73010 ADMIN Travel cost 74000 ADMIN the other is: Trx Date Acc # Acc name 01/04/2006 73010-100-CAN-000 Customer DL - Canada #N/A 28/04/2006 74000-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A Using the formula =VLOOKUP(LEFT(B78,5),ADMIN!$A$1:$B$32,2,FALSE) I get #N/A Wot am i doing wrong? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
By using LEFT in your formula, you are returning a string, but perhaps
the codes in your lookup table are numbers. Try this: =VLOOKUP(VALUE(LEFT(B78,5)),ADMIN!$A$1:$B$32,2,FAL SE) Hope this helps. Pete On Apr 17, 11:26 am, Joe wrote: Is there anything that I might be doing wrong that affects the way Vlookup picks up the numbers? Ie number or text format "Joe" wrote: thanks, that is not the problem. is like the formula doesnt read the number right. Maybe diff format??? how can i change this? thks "Joe" wrote: HI,for some reason it doesnt work for me today. TABLE example: Acc type 73010 ADMIN Travel cost 74000 ADMIN the other is: Trx Date Acc # Acc name 01/04/2006 73010-100-CAN-000 Customer DL - Canada #N/A 28/04/2006 74000-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A Using the formula =VLOOKUP(LEFT(B78,5),ADMIN!$A$1:$B$32,2,FALSE) I get #N/A Wot am i doing wrong?- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
tks. it worked
Rgds, jose "Joe" wrote: HI,for some reason it doesnt work for me today. TABLE example: Acc type 73010 ADMIN Travel cost 74000 ADMIN the other is: Trx Date Acc # Acc name 01/04/2006 73010-100-CAN-000 Customer DL - Canada#N/A 28/04/2006 74000-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A Using the formula =VLOOKUP(LEFT(B78,5),ADMIN!$A$1:$B$32,2,FALSE) I get #N/A Wot am i doing wrong? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
Thanks for feeding back - glad it worked for you.
When you said this in your first post: "... for some reason it doesnt work for me today ..." I assumed that it had worked for you before today, but obviously not. Pete On Apr 17, 1:54 pm, Joe wrote: tks. it worked Rgds, jose "Joe" wrote: HI,for some reason it doesnt work for me today. TABLE example: Acc type 73010 ADMIN Travel cost 74000 ADMIN the other is: Trx Date Acc # Acc name 01/04/2006 73010-100-CAN-000 Customer DL - Canada#N/A 28/04/2006 74000-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A 30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A Using the formula =VLOOKUP(LEFT(B78,5),ADMIN!$A$1:$B$32,2,FALSE) I get #N/A Wot am i doing wrong?- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |