Forum Discussion

KirkL819's avatar
KirkL819
Copper Contributor
Aug 08, 2022

VLookUp formula not working

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:

 

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

excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Silver Contributor
    Aug 08, 2022

    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? 

Resources