VLookUp formula not working

Copper Contributor

Hello All, 

 

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:

Screen Shot 2022-08-08 at 3.00.42 PM.png

 

This is from my second table (however when i select this table the formula lists it as table3):

Screen Shot 2022-08-08 at 3.01.08 PM.png

1 Reply

@KirkL819 

 

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?