HubbaBubba2
New Member
The obvious choice, the "if" statement" for some reason doesn't work as it should. Data to process source cell is A23, or B23. (Never both.)
For column A's data range is
=IF($A$19<>"0",IFERROR(XLOOKUP(B23,'CA SKU Model'!$B$2:$B$255,'CA SKU Model'!$A$2:$A$255),$A$19))
Basically if I can get the A column (row 23 and down) to differentiate based on IF there is a number in the Item Selection box (A19) then it just needs to display it. IF NOT, follow the current path to selecting based on column B's data. Sounds like an "IF" statement for Column A would do it. It sounds simple enough, but doesn't work. (Since oddities like my function keys are out I want to make sure this is also just not the laptop doing this for who knows why."
For column A's data range is
=IF($A$19<>"0",IFERROR(XLOOKUP(B23,'CA SKU Model'!$B$2:$B$255,'CA SKU Model'!$A$2:$A$255),$A$19))
Basically if I can get the A column (row 23 and down) to differentiate based on IF there is a number in the Item Selection box (A19) then it just needs to display it. IF NOT, follow the current path to selecting based on column B's data. Sounds like an "IF" statement for Column A would do it. It sounds simple enough, but doesn't work. (Since oddities like my function keys are out I want to make sure this is also just not the laptop doing this for who knows why."