Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and VLOOKUP
Hello:
Here's my array: A B C 1 Band Service Target 2 6 SAP 95% 3 7 SAP 96% 4 8 SAP 97% 5 9 SAP 80% 6 10 SAP 70% 7 AP SAP 45% 8 6 ORA 93% 9 7 ORA 92% 10 8 ORA 95% 11 9 ORA 90% 12 10 ORA 70% 13 AP ORA 20% 14 6 OTH 80% 15 7 OTH 85% 16 8 OTH 90% 17 9 OTH 85% 18 10 OTH 60% 19 AP OTH 15% I have a list of 500 people that belong to either SAP, ORA or OTH and are of various Bands. Based on their bands and service I need to pull in the target. How do I do that with VLOOKUP and IF functions? Much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |