game_federer
New Member
Dear sirs,
The file Lookuptwocolumns.xlsx gives the model, year, and price for each of a series of cars. Set up formulas that enable you to enter the model and year of a car and return its price.
I was able to do this by add a new column with the concatenation. Is there a way to do this without having to make a new column?
Thank a ton!
The file Lookuptwocolumns.xlsx gives the model, year, and price for each of a series of cars. Set up formulas that enable you to enter the model and year of a car and return its price.
I was able to do this by add a new column with the concatenation. Is there a way to do this without having to make a new column?
Thank a ton!