formula not working

[drewszone32]

I am trying to match up team name on sheet 1 to sheet 2 and if equal take number in sheet 2 and add to sheet 1. the formula is making me multiply the cell at end. It shows correct for first cell then when bringing down formula it shows it multiplying the numbers which i do not want to happen


=MATCH(B9,OH!B$2:B$567,)*OH!E2

 

[Luke M]

Try this:

=VLOOKUP(B9,OH!$B$2:$E$567,4,FALSE)

 

[drewszone32]

Thank you Luke.