One of the formulas I use frequently is not working on my excel sheet. I work with ad campaigns and the formula I use to match ad placement Id's to the ad placement nicknames we give them is now working. Can anyone help me?
Here is the formula and some screenshots: =VLOOKUP([@[Placement ID]],Table3,2,FALSE)
This screenshot is from my first table:
This is from my second table (however when i select this table the formula lists it as table3):
Where in all of this does the formula itself actually appear? I'm assuming it's apart from the area of either of the two screen shots (which, by the way, come up blank when I try to see them enlarged).
Is the formula referring to a specific ID? It looks as if you have the syntax for VLOOKUP correct...... What happens if you replace [@[Placement ID]] with a specific ID?