| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with nested funciton using vlookup
Hello,
I need help with creating a nested function using vlookup. I want to vlookup the cells in Column A (Port Name) and provide the data in Column B (Path ID) and if null, provide the data in Column C (Pending Path ID). I basically need to combine these 2 vlookups: =vlookup(a2,Path_ID,2,false) else =vlookup(a2,Path_ID,3,false) I created a table for the data below called Path_ID Port Name Path ID Pending Path ID T1-1/0/0:01:05 HOLT ROAD-017-1-1 T1-1/0/0:01:06 BELMONT-081-1-3 Thanks! Jaret |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with nested funciton using vlookup
If I understand your request correctly:
=IF(ISBLANK(vlookup(a2,Path_ID,2,false), vlookup(a2,Path_ID,3,false),vlookup(a2,Path_ID,2,f alse) ) This say: IF the first lookup find only a blank THEN use the second lookup ELSE use the first lookup END_IF but I have not tested this - so try it out and let us know best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "mcmilja" wrote in message ... Hello, I need help with creating a nested function using vlookup. I want to vlookup the cells in Column A (Port Name) and provide the data in Column B (Path ID) and if null, provide the data in Column C (Pending Path ID). I basically need to combine these 2 vlookups: =vlookup(a2,Path_ID,2,false) else =vlookup(a2,Path_ID,3,false) I created a table for the data below called Path_ID Port Name Path ID Pending Path ID T1-1/0/0:01:05 HOLT ROAD-017-1-1 T1-1/0/0:01:06 BELMONT-081-1-3 Thanks! Jaret |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with nested funciton using vlookup
Hello Bernard,
Thanks for the help! It looks like this formula just needs a little tweaking...I received "the formula you typed contains an error"...it appears there's an issue with the parenthesis...I looked at each individual function and they all checked out ok...please advise... Thanks! Jaret "Bernard Liengme" wrote: If I understand your request correctly: =IF(ISBLANK(vlookup(a2,Path_ID,2,false), vlookup(a2,Path_ID,3,false),vlookup(a2,Path_ID,2,f alse) ) This say: IF the first lookup find only a blank THEN use the second lookup ELSE use the first lookup END_IF but I have not tested this - so try it out and let us know best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "mcmilja" wrote in message ... Hello, I need help with creating a nested function using vlookup. I want to vlookup the cells in Column A (Port Name) and provide the data in Column B (Path ID) and if null, provide the data in Column C (Pending Path ID). I basically need to combine these 2 vlookups: =vlookup(a2,Path_ID,2,false) else =vlookup(a2,Path_ID,3,false) I created a table for the data below called Path_ID Port Name Path ID Pending Path ID T1-1/0/0:01:05 HOLT ROAD-017-1-1 T1-1/0/0:01:06 BELMONT-081-1-3 Thanks! Jaret |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with nested funciton using vlookup
I figured it out...it was just missing 1 stinking parenthesis after the end
of the 1st vlookup... =IF(ISBLANK(VLOOKUP(A2,Path_ID,2,FALSE)),VLOOKUP(A 2,Path_ID,3,FALSE),VLOOKUP(A2,Path_ID,2,FALSE) ) Thanks a million for the help! Jaret "mcmilja" wrote: Hello Bernard, Thanks for the help! It looks like this formula just needs a little tweaking...I received "the formula you typed contains an error"...it appears there's an issue with the parenthesis...I looked at each individual function and they all checked out ok...please advise... Thanks! Jaret "Bernard Liengme" wrote: If I understand your request correctly: =IF(ISBLANK(vlookup(a2,Path_ID,2,false), vlookup(a2,Path_ID,3,false),vlookup(a2,Path_ID,2,f alse) ) This say: IF the first lookup find only a blank THEN use the second lookup ELSE use the first lookup END_IF but I have not tested this - so try it out and let us know best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "mcmilja" wrote in message ... Hello, I need help with creating a nested function using vlookup. I want to vlookup the cells in Column A (Port Name) and provide the data in Column B (Path ID) and if null, provide the data in Column C (Pending Path ID). I basically need to combine these 2 vlookups: =vlookup(a2,Path_ID,2,false) else =vlookup(a2,Path_ID,3,false) I created a table for the data below called Path_ID Port Name Path ID Pending Path ID T1-1/0/0:01:05 HOLT ROAD-017-1-1 T1-1/0/0:01:06 BELMONT-081-1-3 Thanks! Jaret |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with nested funciton using vlookup
You are most welcome. Thanks for feedback
Bernard "mcmilja" wrote in message ... I figured it out...it was just missing 1 stinking parenthesis after the end of the 1st vlookup... =IF(ISBLANK(VLOOKUP(A2,Path_ID,2,FALSE)),VLOOKUP(A 2,Path_ID,3,FALSE),VLOOKUP(A2,Path_ID,2,FALSE) ) Thanks a million for the help! Jaret "mcmilja" wrote: Hello Bernard, Thanks for the help! It looks like this formula just needs a little tweaking...I received "the formula you typed contains an error"...it appears there's an issue with the parenthesis...I looked at each individual function and they all checked out ok...please advise... Thanks! Jaret "Bernard Liengme" wrote: If I understand your request correctly: =IF(ISBLANK(vlookup(a2,Path_ID,2,false), vlookup(a2,Path_ID,3,false),vlookup(a2,Path_ID,2,f alse) ) This say: IF the first lookup find only a blank THEN use the second lookup ELSE use the first lookup END_IF but I have not tested this - so try it out and let us know best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "mcmilja" wrote in message ... Hello, I need help with creating a nested function using vlookup. I want to vlookup the cells in Column A (Port Name) and provide the data in Column B (Path ID) and if null, provide the data in Column C (Pending Path ID). I basically need to combine these 2 vlookups: =vlookup(a2,Path_ID,2,false) else =vlookup(a2,Path_ID,3,false) I created a table for the data below called Path_ID Port Name Path ID Pending Path ID T1-1/0/0:01:05 HOLT ROAD-017-1-1 T1-1/0/0:01:06 BELMONT-081-1-3 Thanks! Jaret |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with nested funciton using vlookup
Hello Bernard,
What would the formula need to look like if instead of potential null values in the cells, they contained spaces? instead of =IF(ISBLANK) it would be =IF(" ") Thanks! Jaret "Bernard Liengme" wrote: You are most welcome. Thanks for feedback Bernard "mcmilja" wrote in message ... I figured it out...it was just missing 1 stinking parenthesis after the end of the 1st vlookup... =IF(ISBLANK(VLOOKUP(A2,Path_ID,2,FALSE)),VLOOKUP(A 2,Path_ID,3,FALSE),VLOOKUP(A2,Path_ID,2,FALSE) ) Thanks a million for the help! Jaret "mcmilja" wrote: Hello Bernard, Thanks for the help! It looks like this formula just needs a little tweaking...I received "the formula you typed contains an error"...it appears there's an issue with the parenthesis...I looked at each individual function and they all checked out ok...please advise... Thanks! Jaret "Bernard Liengme" wrote: If I understand your request correctly: =IF(ISBLANK(vlookup(a2,Path_ID,2,false), vlookup(a2,Path_ID,3,false),vlookup(a2,Path_ID,2,f alse) ) This say: IF the first lookup find only a blank THEN use the second lookup ELSE use the first lookup END_IF but I have not tested this - so try it out and let us know best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "mcmilja" wrote in message ... Hello, I need help with creating a nested function using vlookup. I want to vlookup the cells in Column A (Port Name) and provide the data in Column B (Path ID) and if null, provide the data in Column C (Pending Path ID). I basically need to combine these 2 vlookups: =vlookup(a2,Path_ID,2,false) else =vlookup(a2,Path_ID,3,false) I created a table for the data below called Path_ID Port Name Path ID Pending Path ID T1-1/0/0:01:05 HOLT ROAD-017-1-1 T1-1/0/0:01:06 BELMONT-081-1-3 Thanks! Jaret |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with nested funciton using vlookup
Hello Bernard,
What would the formula need to look like if instead of potential null values in the cells, they contained spaces? instead of =IF(ISBLANK) it would be =IF(" ") Thanks! Jaret "Bernard Liengme" wrote: If I understand your request correctly: =IF(ISBLANK(vlookup(a2,Path_ID,2,false), vlookup(a2,Path_ID,3,false),vlookup(a2,Path_ID,2,f alse) ) This say: IF the first lookup find only a blank THEN use the second lookup ELSE use the first lookup END_IF but I have not tested this - so try it out and let us know best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "mcmilja" wrote in message ... Hello, I need help with creating a nested function using vlookup. I want to vlookup the cells in Column A (Port Name) and provide the data in Column B (Path ID) and if null, provide the data in Column C (Pending Path ID). I basically need to combine these 2 vlookups: =vlookup(a2,Path_ID,2,false) else =vlookup(a2,Path_ID,3,false) I created a table for the data below called Path_ID Port Name Path ID Pending Path ID T1-1/0/0:01:05 HOLT ROAD-017-1-1 T1-1/0/0:01:06 BELMONT-081-1-3 Thanks! Jaret |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested vlookup? | Excel Discussion (Misc queries) | |||
| Nested VLOOKUP | Excel Worksheet Functions | |||
| VLOOKUP NESTED | Excel Worksheet Functions | |||
| Can Someone Help me With a Nested VLOOKUP | Excel Discussion (Misc queries) | |||
| RANK Funciton | Excel Worksheet Functions | |||
Hybrid Mode
