Query

  • Thread starter Thread starter Jw
  • Start date Start date
J

Jw

Hi,

I have two excel 97 files, the record is over a thousand

File A
Invoice no. Amt
4001 2
4002 3
4003 4
4012 3
4015 5

File B
Invoice no. Pamt Pdate
4001 2 4-7-04
4012 3 13-7-04

I want to create a file to as follow

Invoice no. Amt Pamt Pdate

How to make it under Excel 97 ?? I already tried to use Query or Pivot Table

If I use Access, I use Query to do it and print it but I do not have a
licence in the office.

Please help

Jimmy
 
Hi

Once way is to use VLOOKUP. Try something like:
=VLOOKUP(A2,'FileA'!A:B,2,FALSE) to get the Amt and
=VLOOKUP(A2,'FileB'!A:C,2,FALSE) and
=VLOOKUP(A2,'FileB'!A:C,3,FALSE) for the others
You can then fill these formulas down as required.
 
Back
Top