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

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

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

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

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

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

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