I am trying to get info from two sheets on to one sheet and this is only putting info from Orlando. I am not getting the info from Phoenix.
Code:
=IF(IF('Orlando'!B3<>"",'Orlando'!B3,IF('Orlando'!B3:B$65534="",HLOOKUP('Phoenix'!B$3,'Phoenix'!B$3:B$65534,COUNTBLANK(' Orlando'!B$3:B3),FALSE)))="","",IF('Orlando'!B3<>"",'Orlando'!B3,IF('Orlando'!B3:B$65534="",HLOOKUP('Phoenix'!B3,'Phoenix'!B$3:B$65534,COUNTBLANK('Orlando'!B$3:B3),FALSE))))