Will "IF" Formula Do This...

[andyinla]

My General Ledger is an excel file generated by Finance and has a column with invoice numbers. My Cost Report is a separate excel file that also has an invoice column with invoice numbers

I want to do a formula that will place the month in GL, actual month "02/2009", if the invoice numbers both appear in both reports, General Ledger and Cost Report, so I don't have to go through the Generl Ledger line by line and check did invoice number 66758 apear on my GL for Feb and is that number in Cost Report as well..

How do I go about doing that formula?

Thank you so much

Andy
<!-- / message --><!-- edit note -->

 

[VoG]

You may be able to use VLOOKUP - see http://www.contextures.com/xlFunctions02.html

 

[andyinla]

Thank you for the reply.

Do you know how to write the formula...I have this so far and not working

=VLOOKUP('[Copy of Andrew Haspel (4).xls]Job Cost Detail Report 3'!$G:$G,K423,FALSE)

Copy of Andrew Haspel (4).xls]Job Cost Detail Report 3'!$G:$G,
this is on the GL report and I chose the column with all the invoice numbers G:G

K423 this is on my Cost Report file, cell containing the invoice number

I think I am missing a large step though...

 

[VoG]

Can you post smallish areas of both files using Excel Jeanie http://www.excel-jeanie-html.de/html/hlp_schnell_en.php so that we can get a better idea of what you are trying to do.