Copying cell contents

[torry400]

Hi All
I'm new to this forum and thank you in advance for any help. This may be a straightforward question (not to me unfortunately) and I'll try to be concise with the details:
Hi All
I'm trying to write a cashbook for accounting which has the following:

Column A Date
Column B Class Code (type of expense/income) - this is linked from a separate sheet detailing all the class codes
Column C Description
Columns I:AW Expenses by class

Row 3 Class description
Row 4 Class code

The inputter will only input date, class code and amounts. I want the description column to be populated with the Class code description. eg 1.4.19 ho Hotels from N3, so that Column C would read “Hotels”. Rows 3 and 4 are poplulated from “Codes” sheet.
I am trying to attach a demo version of the cash book which I hope clarifies.
Thanks for any help.

[bebo021999]

Why did not you try VLOOKUP the codes sheet to get the description?

=VLOOKUP(B6,Codes!$A$5:$B$45,2,0)

Besides, from column I to W, I have seen you try to use IF($B6="f0"... with "f0" hard coded, you can use 1 formula in I6:
=IF($B12=I$4,$E12-$H12,0)
then drag down and accross

[torry400]

That's great thank you - works apart from the loss of cell formatting - borders are lost. I had erroneously thought that VLOOKUP could only be used on the furthest left column?