Trying to avoid brute force with if statements

[declan1983]

I am trying to avoid a 50ish if statement if possible.

I have attached a sheet with a rough idea what I am trying to attempt. Basically what I am attempting is:
Sheet1 - the data is just entered based on criteria from another sheet
Sheet2 - Row20 data is copied from Sheet3!C3, Sheet3!D3 etc.
Row21 is where the issues arises -

Please Login or Register  to view this content.

- This formula would then be copied across the page in the yellow cells.
It becomes brute force because the sheet this will go into goes up to BJ4/BJ5.

[6StringJazzer]

Try this in column B then you can copy and paste it to all the other yellow cells.

Please Login or Register  to view this content.

The cells in Sheet2 row 20 must be formatted as General. Currently they are Text. As Text, they will not match the values on Sheet1.

[declan1983]

Perfect, thank you, one of these days I will eventually learn how to use the Index and match.