Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If function with Vlookup
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". |
#2
|
|||
|
|||
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(B20,VLOOKUP(A2,Sheet2!A:B,2,FALSE))), 100,IF(B20,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 "lil'bibbib" wrote in message ... 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". |
#3
|
|||
|
|||
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) "lil'bibbib" wrote in message ... 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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Function | Excel Discussion (Misc queries) | |||
How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
VLOOKUP Function using Data Ranges. | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions |