i have several tables on several sheets I am trying to type in a “Ticket #” on a table “x” in cell c3 and have it reference table “z” on “sheet.Ticket#” to get the name associated with that number (First(b2), Last name(c2)) and place it in A3 in the original table. $lookup is not working for this, need help with making a VBA.
i have tried using all of lookup fx and none are returning the data.
New contributor
James Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.