Excel Extracting data from sheet depending on availability
Hope you can help
I have a packing list template that pulls various information based on what is pasted into two separate sheets
It currently pulls information from two sheets – Paste Invoice & Paste Manual Excel Pick Sheet
What I’m struggling to do effectively is that the main body of the packing list pull the data primarily from the Paste Manual Excel Pick Sheet tab and if there is nothing available in there, then it reverts for the Paste invoice sheet
At present, my formula isn’t recognising beyond line 70 on Paste Manual Excel Pick Sheet when I delete the data on the Paste invoice tab
=IF(AND('Paste Invoice'!A70<>"",'Paste Manual Excel Pick Sheet'!B71<>""),'Paste Manual Excel Pick Sheet'!B71&'Paste Manual Excel Pick Sheet'!C71,'Paste Invoice'!A70)
So this is saying if Paste Invoice A70 and Paste Manual B71 BOTH contain values (neither is blank) then join Paste Manual B71 & C71 otherwise use Paste Invoice A70.
On this particular example Paste Invoice A70 is blank so the AND condition (both contain values) is false so the IF statement is using the second option Paste Invoice A70 which is blank so result is 0.
What are you expecting to happen?