I have imported into Excel our accounting spreadsheet. by way of example the
accounting code for Contract labor is 601601 and it is located in the
imported spreadsheet at A39. I want to do a logical If question and I get a
fals reading.
My formula is:
=If([accountingfile.xlsx]sheet1!a39=601601,Q39,false)

I get the false readin even if a39 = 601601, Why? The only thing I come up
with is the formatting of the a39 cell in my imported file. I have tried to
typoe in a39="601601 or a39= 601601 and a39='6016 and a39= '601601 I
get the same false.

I tried in my worksheet to use a differet cell to import the A39 and then
insert that cell into the if formula and I still get false but you can see
the number 601601 in the cell right above my if formula.