Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Y&X show Z but only in A & B are correct
Help,
I am trying to create a spreadsheet that numpties can use only to be stumped myself! I want to look up a value in column X and Y show column Z, but only if column B and C are both correct. ie if b = engineer and c= upper then it needs to look for engineer in X and upper in Y and display the rate in Z Columns B&C i will use as a drop down selection box to get the correct titles and grade. X Y Z Engineer Upper £3 Engineer Middle £2 Engineer Lower £1 Foreman Upper £1.4 Foreman Lower £1.2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Y&X show Z but only in A & B are correct
Try this:
=SUMPRODUCT(--(X1:X5=A1),--(Y1:Y5=B1),Z1:Z5) -- Biff Microsoft Excel MVP "JK494" wrote in message ... Help, I am trying to create a spreadsheet that numpties can use only to be stumped myself! I want to look up a value in column X and Y show column Z, but only if column B and C are both correct. ie if b = engineer and c= upper then it needs to look for engineer in X and upper in Y and display the rate in Z Columns B&C i will use as a drop down selection box to get the correct titles and grade. X Y Z Engineer Upper £3 Engineer Middle £2 Engineer Lower £1 Foreman Upper £1.4 Foreman Lower £1.2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula is correct, but result will not show | Excel Worksheet Functions | |||
Getting correct results for lookup? | Excel Discussion (Misc queries) | |||
my pivot tables are correct but my totals and GT don't show | Excel Discussion (Misc queries) | |||
A correct IF function doesn't show the function's result in cell | Excel Discussion (Misc queries) | |||
show difference between weights with correct pos and neg values | Excel Worksheet Functions |