| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with IF and VLOOKUP combined
I want to do the following:
I have data which says Postcode Equipment 1 Equipment 2 SE David Bob B Bill James and I have sales Invoice Value Postcode Equipment type 1 £10 SE 1 2 £20 SE 2 and I want a formula to return the name of the sales rep depending on equipment type. I have entered =IF(U2,"Acute Care",(VLOOKUP(V2,Salespersons!A:C,2,FALSE)),VLOOK UP(V2,Salespersons!A:C,3,FALSE)) U2 = Equipment type V2 = Postcode This is wrong so can anyone help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup combined with Hlookup | Excel Worksheet Functions | |||
| VLOOKUP combined with AND | Excel Discussion (Misc queries) | |||
| vlookup combined with AND-function | Excel Worksheet Functions | |||
| vlookup and match combined? | Excel Worksheet Functions | |||
| Combined VLOOKUP AND BETWEEN FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
