Thread: VBA Help

I have a table with Tickers and ID's.

ABC A1
XYZ A2
123 A3

Now I have my portfolio with the column names, ticker, CUSIP, ID.

In the ID tab I want to have the function do a vlookup on the ticker in the table with the tickers and ID's and give the result.

I also want it where if the ticker is not found in the table, it defaults back to A1.

This is what I have, but I doubt I'm even close to correct.



Function PortID(Ticker)
With Sheets("Portfolios")

PortID = Application.WorksheetFunction.VLookup(Ticker, Range("'Portfolios'!$B$14:$C$23"), 2, False)
If PortID = "#N/A" Then
PortID = Cells.C14

End If
End With
End Function



I have attached a file so you can see what I'm attempting to do.

Looking at the first one if upon the VLOOKUP, NWRXX is not found in the table, then result = A1. If it is found, give the corresponding Port-ID.

Thanks for the help.