Hello from Steved

4284 640 "Both worksheets have the same information in both columns

Ok whats my issue
I import A "Oracle file" into my spreadsheet the below formula is not
working, now if I copy "4284 and "640" into the imported worksheet it works.
I know "+0" sees text and treats it as a number, my question is their
something similar please.
=INDEX(Timetables!$F$2:$F$5000,MATCH(1,(Timetables !$E$2:$E$5000=B71)*(Timetables!$D$2:$D$5000=C71),0 ))

Thankyou.