Hi,
I was wondering if I is possible for excel to read data found in 3 cells to find a number associated with those 3 cells on another sheet and insert that number back on the first sheet.
[TABLE="width: 180"]
<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" span="3"> <tbody>[TR]
[TD="width: 80, bgcolor: transparent"][TABLE="width: 240"]
<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" span="4"> <tbody>[TR]
[TD="width: 80, bgcolor: transparent"]11001[/TD]
[TD="width: 80, bgcolor: transparent"]11002[/TD]
[TD="width: 80, bgcolor: transparent"]11003[/TD]
[TD="width: 80, bgcolor: transparent"]11003[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]BVLD TCE-BL[/TD]
[TD="bgcolor: transparent"]BVLD TCE-BL[/TD]
[TD="bgcolor: transparent"]BVLD TCE-BL[/TD]
[TD="bgcolor: transparent"]BVLD TCE-BL[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]HORSESHOE[/TD]
[TD="bgcolor: transparent"]DOWNTOWN
[/TD]
[TD="bgcolor: transparent"]HORSESHOE[/TD]
[TD="bgcolor: transparent"]REACTIVE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]XXXXXXX[/TD]
[TD="bgcolor: transparent"]XXXXXXX[/TD]
[TD="bgcolor: transparent"]XXXXXXX
[/TD]
[TD="bgcolor: transparent"]XXXXXXX
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][TABLE="width: 657"]
<colgroup><col width="91" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;"> <col width="574" style="width: 431pt; mso-width-source: userset; mso-width-alt: 20992;"> <col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;"> <col width="56" style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048;"> <tbody>[TR]
[TD="width: 91, bgcolor: transparent"]11037 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="width: 154, bgcolor: transparent"]HORSESHOE[/TD]
[TD="width: 56, bgcolor: transparent, align: right"]3017518[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11041 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]HORSESHOE[/TD]
[TD="bgcolor: transparent, align: right"]3002502[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11045 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]HORSESHOE[/TD]
[TD="bgcolor: transparent, align: right"]3017591[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11001 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]DOWNTOWN[/TD]
[TD="bgcolor: transparent, align: right"]3012453[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11002 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]DOWNTOWN[/TD]
[TD="bgcolor: transparent, align: right"]3007534[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11003 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]DOWNTOWN[/TD]
[TD="bgcolor: transparent, align: right"]3010712[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11004 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]DOWNTOWN[/TD]
[TD="bgcolor: transparent, align: right"]3002970[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]For example, I would like excel to read 11002, BVLD TCE-BL, and DOWNTOWN and give me the number 3007534 where the X's are. An IF statement would not work in this situation as there are 21000+ rows in the file.
Thank you for the help
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
I was wondering if I is possible for excel to read data found in 3 cells to find a number associated with those 3 cells on another sheet and insert that number back on the first sheet.
[TABLE="width: 180"]
<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" span="3"> <tbody>[TR]
[TD="width: 80, bgcolor: transparent"][TABLE="width: 240"]
<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" span="4"> <tbody>[TR]
[TD="width: 80, bgcolor: transparent"]11001[/TD]
[TD="width: 80, bgcolor: transparent"]11002[/TD]
[TD="width: 80, bgcolor: transparent"]11003[/TD]
[TD="width: 80, bgcolor: transparent"]11003[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]BVLD TCE-BL[/TD]
[TD="bgcolor: transparent"]BVLD TCE-BL[/TD]
[TD="bgcolor: transparent"]BVLD TCE-BL[/TD]
[TD="bgcolor: transparent"]BVLD TCE-BL[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]HORSESHOE[/TD]
[TD="bgcolor: transparent"]DOWNTOWN
[/TD]
[TD="bgcolor: transparent"]HORSESHOE[/TD]
[TD="bgcolor: transparent"]REACTIVE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]XXXXXXX[/TD]
[TD="bgcolor: transparent"]XXXXXXX[/TD]
[TD="bgcolor: transparent"]XXXXXXX
[/TD]
[TD="bgcolor: transparent"]XXXXXXX
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][TABLE="width: 657"]
<colgroup><col width="91" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;"> <col width="574" style="width: 431pt; mso-width-source: userset; mso-width-alt: 20992;"> <col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;"> <col width="56" style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048;"> <tbody>[TR]
[TD="width: 91, bgcolor: transparent"]11037 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="width: 154, bgcolor: transparent"]HORSESHOE[/TD]
[TD="width: 56, bgcolor: transparent, align: right"]3017518[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11041 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]HORSESHOE[/TD]
[TD="bgcolor: transparent, align: right"]3002502[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11045 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]HORSESHOE[/TD]
[TD="bgcolor: transparent, align: right"]3017591[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11001 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]DOWNTOWN[/TD]
[TD="bgcolor: transparent, align: right"]3012453[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11002 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]DOWNTOWN[/TD]
[TD="bgcolor: transparent, align: right"]3007534[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11003 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]DOWNTOWN[/TD]
[TD="bgcolor: transparent, align: right"]3010712[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]11004 [/TD]
[TD="width: 574, bgcolor: transparent"]BLVD TCE-BL[/TD]
[TD="bgcolor: transparent"]DOWNTOWN[/TD]
[TD="bgcolor: transparent, align: right"]3002970[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]For example, I would like excel to read 11002, BVLD TCE-BL, and DOWNTOWN and give me the number 3007534 where the X's are. An IF statement would not work in this situation as there are 21000+ rows in the file.
Thank you for the help
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]