View Single Post
  #4  
Old 5th May 2018, 06:27 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

This code solved my issues.

=IF(AQ2="","",LOOKUP(9E+99+307,SEARCH(Data!$AW$23ata!$AW$98,A Q2),Data!$AX$23ata!$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
_______________________________________________
Reply With Quote