Whats wrong with this formula?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

In A169 I have a data valadation with name define CH_NAMES witch is A
column then in ABC Columns I have name define CH_NAMES_BANK , I am getting
#ref but if i change 2,0 to 1,0 I get whats in A column
=IF(ISNA(VLOOKUP(A169,CH_NAMES_BANK,2,0)),"",VLOOKUP(A169,CH_NAMES_BANK,2,0)
)
--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Ah Ha doesn't work on the same sheet, Thanx anyway

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Back
Top