how to get excel to fill the details as per the code given

[sumesh56]

i want to get the details entered automatically when i enter a code in col B. how can i achive this . pls see the file attached.

[Glenn Kennedy]

The best way is using a simple lookup table. I have put it in J2 to M9, but it can go anywhere and can be hidden.

Formula in D2, copied across and down:

=VLOOKUP($B2,$J$2:$M$9,COLUMNS($D$2:D2)+1,FALSE)

[sumesh56]

The best way is using a simple lookup table. I have put it in J2 to M9, but it can go anywhere and can be hidden.

Formula in D2, copied across and down:

=VLOOKUP($B2,$J$2:$M$9,COLUMNS($D$2:D2)+1,FALSE)

thanks a lot for the suggestions. have a nice day.

[Glenn Kennedy]

You're welcome and thanks for the Rep.