View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike R.
 
Posts: n/a
Default If Statement linked to cell with VLOOKUP problem - getting wrong v

Hi,
I have a simple IF statement that is =IF(A1A2,A1,A2). The cell A1 is a
VLOOKUP to get the value. This seems to be giving me a false answer in my If
statement and it always equals the value in A1. If I just type in the value
of A1 (to test it), the If statement works properly.... help.
Mike