What is the lookup formula to search in multiple columns

[Ramadan2512]

I have a worksheet table with 4 columns containing employee name and 4 columns for ID number for this employee

simply and I need a formula to add the employee ID number which is next to the name if the cell match any cell of the employees names in the 4 columns ("B , D , F or H")
for example as you can see in the attached screenshot

in cell C10 I need to add a formlua which is (if B10= any of names in columns (B,D,F,H) then add the ID number of this employee in the cell C10)

please I need to know what is the lookup or vlookup or xlookup or any other formula to do that

 

[Ramadan2512]

Replace Fluff's SUMIF with MAXIFS

=MAXIFS(C3:I6,B3:H6,B10)

Thanks Cubist , this is the nearest solution if there is a repeated name with different ID number this formula gives me the last match of the Employee ID - good