| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple if statement with vlookup function
Good day!
I was hoping someone could help me with what is probably a very simple formula. I have a sheet that holds customer data with different products and prices. On a separate sheet with past customer purchases, I would like to formula to tell me what the first sheet says the customer should pay today if they bought that particular product. example: Sheet 1: Customer1234 WASTEOIL252 4,000L Customer1234 WASTEOIL253 500L Sheet 2: Customer1234 WASTEOIL252 .05CPL Customer1234 WASTEOIL253 .10CPL Any suggestions? -- Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement with Vlookup - including ISNA function to compare two columns from different worksheets | Excel Worksheet Functions | |||
| Can we use multiple if with VLookup function | Excel Worksheet Functions | |||
| Multiple If and Vlookup function | Excel Worksheet Functions | |||
| How do I get multiple matches when using the Vlookup function? | Excel Worksheet Functions | |||
| VLOOKUP Function using multiple worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
