Vlookup formula for two Columns

Hi,
Not sure if i can do this with a VLookup or if i need a Match/Index formula, either way i'll need some help with the syntax.
I want to check the value in two columns on one row from a table within the workbook.
I'm currently using this formula to check one column:
=IFERROR(VLOOKUP(AI2,Consultant!$A$2:$B$117,2,FALSE),"No Consultant")
But i need it to check column AJ too. If it finds a value within the lookup table (from either column) then i want it to display the value in the B column of the lookup table.
Does that make sense?
Thanks,
Peter

Maybe
=IFERROR(VLOOKUP(AI2,Consultant!$A$2:$B$117,2,FALSE),IFERROR(VLOOKUP(AJ2,Consultant!$A$2:$B$117,2,FALSE),"No Consultant"))

This seems to be the one, thank you for this, much appreciated

You're welcome & thanks for the feedback.