Look between two lists to find result, and another by ID.

[Cyberpawz]

It either seems that I am the only person that looks for these things, or no one seems to ask...I hate asking, but looking on the net has caused my head to implode.

I am looking to use the original script on the sheet and pull information from two lists. I also need the ability to type in an ID, and find a name like shown on the sheet between the two lists and show the correct results.

So it will show not only the ID of the name, but where it resides. Is this possible?

Attached is the sheet... thanks again for the help.

[NBVC]

In C3, try:

=IFERROR(INDEX($I$10:$I$13,MATCH(1,INDEX(($G$10:$G$13=A3)*($H$10:$H$13=B3),0),0)),IFERROR(INDEX($M$10:$M$13,MATCH(1,INDEX(($K$10:$K$13=A3)*($L$10:$L$13=B3),0),0)),""))

in D3, try:

=IF(ISNUMBER(MATCH(C3,$I$10:$I$13,0)),$G$8,IF(ISNUMBER(MATCH(C3,$M$10:$M$13,0)),$K$8,""))

copy both cells and paste to C7, C11, etc...

[Cyberpawz]

In C3, try:

=IFERROR(INDEX($I$10:$I$13,MATCH(1,INDEX(($G$10:$G$13=A3)*($H$10:$H$13=B3),0),0)),IFERROR(INDEX($M$10:$M$13,MATCH(1,INDEX(($K$10:$K$13=A3)*($L$10:$L$13=B3),0),0)),""))

in D3, try:

=IF(ISNUMBER(MATCH(C3,$I$10:$I$13,0)),$G$8,IF(ISNUMBER(MATCH(C3,$M$10:$M$13,0)),$K$8,""))

copy both cells and paste to C7, C11, etc...

And to type in an ID and getting the correct number? Is that possible by one of the scripts you have here?

[Cyberpawz]

Figured it out...

[code]=IFERROR(INDEX($H$10:$H$13,MATCH(1,INDEX(($I$10:$I$13=$C$11)*($I$10:$I$13=$C$11),0),0)),IFERROR(INDEX($L$10:$L$13,MATCH(1,INDEX(($M$10:$M$13=$C$11)*($M$10:$M$13=$C$11),0),0)),""))/code]

Thanks for the help