Compare two workbooks and pull in info from one into the other

Hi,

Who can help me out with this complex problem ?
I have two separate workbooks.
One very large with invoice details per cell phone users.
The second one with payment references from Accounting.
I am looking for a way to pull in the payment details from the Accounting sheet into my workbook with the detailled invoice overview.
The corresponding field in both workbooks is the invoice reference.
So I want excel to compare the invoice reference and if corresponding it should pull in the entire line of Accounting payment details after my last column in my cell phone overview sheet.

Thanks in advance,
Dbase Beginner

I am not sure how you can get the whole line pulled in, in one shot, but you could do a series of VLOOKUPs. Just put the formulas in the columns at the end of your cell phone overview sheet.

The 1st one looks something like this:

=VLOOKUP(a1,'[accounting]sheet1!'$a$1:$g$65536,1,false)

a1 = cell your 1st invoice ID is in on the cellphone sheet
the name in the [ ] is the name of the accounting spreadsheet
sheet1 = the name of the tab on the accounting spreadsheet
$a$1 = the beginning of your range (where the invoice ID is on the accounting spreadsheet....this must be the 1st column in your range)
$g$65536 = the end of your range (if you want to bring back the whole row, make sure your entire spreadsheet is included in this range)
1 = the column in your range that you want to bring into your cellphone sheet from the accounting sheet
false = look for an exact match
Paste this formula down the length of the column


Then, just copy this formula to as many rows as you need to bring back all info. You will just change the 1 to represent the column number you want to bring back.

I hope this helps. Good luck.

If I am reading this right I think the vlookup formula should work for you. If the accounting sheet has multiple columns you would have to have a vlookup for each column you wanted to pull over (unless you wanted all the info in one column). If you don't want a lot of N/A's showing up use a IF(ISNA() with the vlookup similar to below.

=if(isna(vlookup(a1,othersheet!a1:g30,3,false),"",vlookup(a1,othersheet!a1:g30,3,false))


Hope this helps.