Formatting Data Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I import data from my accounts package it is not lined up against
previous imported data. How can I line the rows up so I can subtract one
column away from another.

A B C D E F G H
110 250 Wages 100.00 110 250 Wages 100.00
120 310 Advert 564.00 125 564 Misc 654.00
125 564 Misc 654.00 130 425 Training 854.00

A is the Cost centre, B is the Expense code, C is the detail and D is the
Amount.
 
A B C D E F G H I
110 250 Wages 100.00 110 250 Wages 100.00 formula
120 310 Advert 564.00 125 564 Misc 654.00
125 564 Misc 654.00 130 425 Training 854.00
Click to expand...

Insert this formula in I1
=VLOOKUP(E1,A1:D3,4,FALSE)

It will return the value from column D that matches cost center in column E.
Then you can calculate the difference between column H and I.

Regards,
Stefi

„nigerobinson†ezt írta:
 
Hi Stefi

It still willn't work ?

Stefi said:
Insert this formula in I1
=VLOOKUP(E1,A1:D3,4,FALSE)

It will return the value from column D that matches cost center in column E.
Then you can calculate the difference between column H and I.

Regards,
Stefi

„nigerobinson†ezt írta:
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Data Lists 1
Formula Help .. please 1
if value is between two numbers 6
Dynamic database extraction for reporting 2
Sumproduct puzzler - apologies for incorrect post to Programming 11
(Part 2) - Retrieve Numeric Label for Max Value by Specific Day & Month 4
lookup over several columns 2
Sumproduct forumla for complex sum. 16

Back
Top