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