Forum Discussion
IF AND statement referencing other workbook formula error
Hi all, I hope you're well. I've got a drop down box that shows options from a table in another worksheet. There is then a second drop down box whose options populate from the same table depe...
What happens when you create the formula in the sheet containing the table and subsequently cut that cell and paste it in the other worksheet? Shouldn't you ne using one of the Lookup functions, probably XLOOKUP, rather than a bunch of nested IF's?