![Old](images/statusicon/post_old.gif)
5th May 2018, 07:27 PM
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,455
|
|
This code solved my issues.
=IF(AQ2="","",LOOKUP(9E+99+307,SEARCH(Data!$AW$23 ![Big Grin](images/smilies/biggrin.gif) ata!$AW$98,A Q2),Data!$AX$23 ![Big Grin](images/smilies/biggrin.gif) ata!$AX$98))
__________________
One Drive
"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________
|