VLookup if field is a formula

[Mindre]

If I am using a Vlookup and the lookup value is a formula, does excel read the formula and not the actual data (number of words) in the cell? I thought it read the data rather tha nthe formula but I am running into issues using

=VLOOKUP(C20,'Client DB'!F:I,3,0)

It keeps returning NA but I know the data exists

 

[Saba Sabaratnam]

Hi,

It does look up result of formula not formula.

NA might be caused by:

 

[Saba Sabaratnam]

1 . C20 has number and lookup array has the same number stored as text or vise versa
2. Invisible spaces in C20 or lookup array

Kind regards

Saba