Hi,

I'm having problems with my vlookup formula and can't understand what's going on. It's correctly working as it is finding the proper rows but whenever it finds data it returns a "Value not available" error message. I've tried formatting the cells, sorting etc. but nothing is changing. Perhaps I should rewrite my formula :

=IF(OR($I15="SAN";$I15="SANCH";$I15="HER")*AND($T15="#");VLOOKUP($A15;Table1[#All];25;0);"")

Any help would be appreciated
amphinomos