Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MATCH Question
I'm going to try this one more time. As I keep working
I'm find some of the answers to my questions, however there's one I just can't figure out. Here's what I have now: Sheet Name: Active I Q U Union Local Job CodeA Rate Code Sheet Name: Job Codes A B C J Union Local Job CodeA JobCodeB Rate Code Here the formula that I'm trying to put into the sheet named Active {=INDEX(Job_CodeB,MATCH(Active!Q1&Active!I1&Active ! U1,Job_CodeA&union_local&Rate_Code,1))} This returns JobCodeB that matches JobCodeA, Union Local and Rate code. The formula works fine for the first 28 rows, then it stops. What am I doing wrong? |
#2
|
|||
|
|||
Hi
what exactly happens afterwards?. Maybe try: {=INDEX(Job_CodeB,MATCH(Active!Q1&Active!I1&Active ! U1,Job_CodeA&union_local&Rate_Code,0))} to search for an exact match -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I'm going to try this one more time. As I keep working I'm find some of the answers to my questions, however there's one I just can't figure out. Here's what I have now: Sheet Name: Active I Q U Union Local Job CodeA Rate Code Sheet Name: Job Codes A B C J Union Local Job CodeA JobCodeB Rate Code Here the formula that I'm trying to put into the sheet named Active {=INDEX(Job_CodeB,MATCH(Active!Q1&Active!I1&Active ! U1,Job_CodeA&union_local&Rate_Code,1))} This returns JobCodeB that matches JobCodeA, Union Local and Rate code. The formula works fine for the first 28 rows, then it stops. What am I doing wrong? |
#3
|
|||
|
|||
Thank you, That was so obvious. It's been a long day of
staring at the screen and working on this same formula. I'm going to lunch. thanks again. -----Original Message----- Hi what exactly happens afterwards?. Maybe try: {=INDEX(Job_CodeB,MATCH(Active!Q1&Active!I1&Activ e! U1,Job_CodeA&union_local&Rate_Code,0))} to search for an exact match -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I'm going to try this one more time. As I keep working I'm find some of the answers to my questions, however there's one I just can't figure out. Here's what I have now: Sheet Name: Active I Q U Union Local Job CodeA Rate Code Sheet Name: Job Codes A B C J Union Local Job CodeA JobCodeB Rate Code Here the formula that I'm trying to put into the sheet named Active {=INDEX(Job_CodeB,MATCH(Active!Q1&Active!I1&Active ! U1,Job_CodeA&union_local&Rate_Code,1))} This returns JobCodeB that matches JobCodeA, Union Local and Rate code. The formula works fine for the first 28 rows, then it stops. What am I doing wrong? . |
#4
|
|||
|
|||
Hi Phyllis
What does Job_CodeB refer to when you go to insert / name / define and click on it? same question for Job_CodeA&union_local&Rate_Code Cheers JulieD "Phyllis" wrote in message ... I'm going to try this one more time. As I keep working I'm find some of the answers to my questions, however there's one I just can't figure out. Here's what I have now: Sheet Name: Active I Q U Union Local Job CodeA Rate Code Sheet Name: Job Codes A B C J Union Local Job CodeA JobCodeB Rate Code Here the formula that I'm trying to put into the sheet named Active {=INDEX(Job_CodeB,MATCH(Active!Q1&Active!I1&Active ! U1,Job_CodeA&union_local&Rate_Code,1))} This returns JobCodeB that matches JobCodeA, Union Local and Rate code. The formula works fine for the first 28 rows, then it stops. What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I customize the X-axis in excel to match my dataset? | Charts and Charting in Excel | |||
Simple VBA question | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions | |||
Use MATCH to find position of max in 2D range? | Excel Worksheet Functions |