I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and when I put my vlookup in the blank cell referencing this cell (as i want the actual value) I get #N/A.

My vlookup formula is

```
=vlookup(F57,'LOCATION LOOKUP TABLE'!B:C,2,0)
```

Can someone tell me if I need to remove the formula from the other cell so that my formula will work or do someone have another way that I can make this work without changing anything?

`VLOOKUP`

contains a formula or a fixed value. Can you describe what is in columns B and C on the`LOCATION LOOKUP TABLE`

sheet and what is in cell`F57`

?`FALSE`

(`0`

),`VLOOKUP`

returns`#N/A`

if an exact match is not found. As bdr9 already said, it doesn't matter if the specified table array itself contains formulas.