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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with IF and VLOOKUP combined
As you don't list column references, this is somewhat of a guss, but your
structure will be: =INDEX(Salespersons!A:C,MATCH(V2,Salespersons!A:A, 0),W2+1) This assumes that V2 lists Postcode, and W2 is your Equipment Type (entered as a number), and your Salespersons data is in columns A:C, with Postcode being in column A. You didn't say anything about U2 or "Acute Care", but throwing that part of your formula in: =IF(U2,"Acute Care",INDEX(Salespersons!A:C,MATCH(V2,Salespersons !A:A,0),W2+1)) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Natalie" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with IF and VLOOKUP combined
I see now at bottom of post where your cell references are. Adjusting formula:
=INDEX(Salespersons!A:C,MATCH(V2,Salespersons!A:A, 0),U2+1) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Natalie" wrote: 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? |
Reply |
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 |