ExcelBanter - if A is x then B is y

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if A is x then B is y (https://www.excelbanter.com/excel-discussion-misc-queries/137001-if-x-then-b-y.html)

Arianit Dobroshi

if A is x then B is y

I have column A (known) and B (to be filled out). I want excel to look
at A and fill out B based on the value of A. So let's say whenever
there is a "DA" value in the Type column, then write "210" in
Horsepower field next to it across multiple sheets. If I have 20
types, can I do this in one formula or do I have to repeat the
procedure for every type?

Type Horsepower
AA ???
DA ???
RE ???

Barb Reinhardt

if A is x then B is y

Take a look at the VLOOKUP function.

"Arianit Dobroshi" wrote:

I have column A (known) and B (to be filled out). I want excel to look
at A and fill out B based on the value of A. So let's say whenever
there is a "DA" value in the Type column, then write "210" in
Horsepower field next to it across multiple sheets. If I have 20
types, can I do this in one formula or do I have to repeat the
procedure for every type?

Type Horsepower
AA ???
DA ???
RE ???

All times are GMT +1. The time now is 12:56 PM.