Hi, This is what I’m trying to figure out. I have Sheet1 that has an income statement colA name of accounts and I want numbers to go in ColD (this is where my formula will be) from Sheet2 .
Sheet2 colA has account names and ColB has a numbers. I want to compare the text between sheets 1 & 2 for colA , then if true then return the number from Sheet2 ColB.
This is the formula i tried bur got a =IF((A8:A70)=sheet2(A8:A70),sheet2(B3:B70),"–") . I get a 508 error code
Thanks
Ann