L
LoriM
=INDEX(Gaps!$C$9:$C$2103,MATCH(1,(Gaps!$A$9:$A$2103=A2)*(Gaps!$D$9:$D$2103=F2),0))
works great for getting me the correct acct #. Thank you again Frank!
But now I need to take it a step further... The data that I'm working with
will eventually be imported into another database program where we already
have some of this data. We do not want duplicate data so I need to delete out
what has already been input to the database.
On my main sheet, cell P2 contains the month # for that invoice.
On Gaps page my columns look like this:
A B C D E F G H I
Site Fuel Acct Meter Feb'04 Mar Apr May June
0001 Electricity 10241 E0001-1 4 5
If the data has already been entered into the database, I have manually
placed the month number in the column. Now the tricky part.
On my main sheet, I need to have Period (cell P2) cross-referenced with that
particular account/meter on Gaps page and tell me if we already have the
data. My goal is to create a column at end (column R) marking the rows as
delete if I already have the information.
I have searched & searched help, communities, etc. Perhaps I am not
searching for the correct text.
Thanks so much for any response -- very, very appreciated!
works great for getting me the correct acct #. Thank you again Frank!
But now I need to take it a step further... The data that I'm working with
will eventually be imported into another database program where we already
have some of this data. We do not want duplicate data so I need to delete out
what has already been input to the database.
On my main sheet, cell P2 contains the month # for that invoice.
On Gaps page my columns look like this:
A B C D E F G H I
Site Fuel Acct Meter Feb'04 Mar Apr May June
0001 Electricity 10241 E0001-1 4 5
If the data has already been entered into the database, I have manually
placed the month number in the column. Now the tricky part.
On my main sheet, I need to have Period (cell P2) cross-referenced with that
particular account/meter on Gaps page and tell me if we already have the
data. My goal is to create a column at end (column R) marking the rows as
delete if I already have the information.
I have searched & searched help, communities, etc. Perhaps I am not
searching for the correct text.
Thanks so much for any response -- very, very appreciated!