i have a row with 45 columns on sheet a that reference to a row on sheet b
Its duplicated 40 times sheet a, this way i can change the change the data on sheet b and it will be changed all 40 times.

what i want to so is add a control on sheet a like so.

if cell A1 = 1 then use data from this row on sheet b
if cell A1 = 2 then use data from this row on sheet b
and so on

Should i use a nested if or is there a simpler better way to do this?

Probably depends on how deep your IF has to go. Is it a choice between 2 values or 30 values?

If it's just 2, use a nested if. If it's a bunch, you may want to use a macro.

its just 3, thanks

Yeah, you shouldn't even notice a performance issue at that level.

With that few it shouldn't be a problem. An alternative if it is more is to use a lookup table, which doesn't require VBA.