I'm not sure what you are trying to do but maybe Vlookup would help?

"sedonovan" wrote:

if a value is entered at A1 is is possible to populate other columns with
default values, or is this an Access feature only?