Hello from Steved

Below I have 2 formulas the first works the second does not

Ok my objective is that on A566 I have E19 and on All Bus Models I have 19,
What do I need to do please if I put in A566 it will pick up the value from
All Bus Models.
Thankyou.

=IF(ISNA(VLOOKUP(--$A566,'All Bus
Models'!$A$5:$C$5000,2,FALSE)),VLOOKUP(--$A566,'All Bus
Models'!$A$5:$C$5000,2,FALSE),VLOOKUP(19,'All Bus
Models'!$A$5:$C$5000,2,FALSE))

=IF(ISNA(VLOOKUP(--$A566,'All Bus
Models'!$A$5:$C$5000,2,FALSE)),VLOOKUP(--$A566,'All Bus
Models'!$A$5:$C$5000,2,FALSE),VLOOKUP(A566,'All Bus
Models'!$A$5:$C$5000,2,FALSE))