If function with Vlookup

[Guest]

Hello... I am currently building database for my July and August customers.
Because I am doing a promotion, those that purchased in July will be able to
get a free course in August. I would like to know how do I build it so that
in the "Amount" column, it would search July data and if the customer number
corresponds then it will return the invoice number in July (which is set up
next to the "Amount" column) and if cant find the customer number, then it
should display "100".

 

[CLR]

It's hard to describe with no more info to go on, but assume

Sheet1 cell A1=CustNo., cell B1=Amount, cell C1=JulyAmt
Sheet 2 would have the same headings in A1 and B1, and would be filled with
the July data
Put this formula in Sheet1 C2 and copy down..........

=IF(ISNA(IF(B2>0,VLOOKUP(A2,Sheet2!A:B,2,FALSE))),100,IF(B2>0,VLOOKUP(A2,She
et2!A:B,2,FALSE)))

It's all one formula, watch out for the email work-wrap. Of course you may
have to change the cell references to match your data, but this will give
you an idea...........

Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

Do you mean something like

=IF(ISNUMBER(MATCH(A2,July!A2:A100,0)),VLOOKUP(A2,July!A2:H100,5,False),100)

where A2 is the customer number and the invoice number is in column E on the
July sheet

--

HTH

RP
(remove nothere from the email address if mailing direct)