Lookup values in multiple cells

[NSegna]

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.

11001 11002 11003 11003 BVLD TCE-BL BVLD TCE-BL BVLD TCE-BL BVLD TCE-BL HORSESHOE DOWNTOWN HORSESHOE REACTIVE XXXXXXX XXXXXXX XXXXXXX XXXXXXX <colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" span="4"> <tbody> </tbody>
11037 BLVD TCE-BL HORSESHOE 3017518 11041 BLVD TCE-BL HORSESHOE 3002502 11045 BLVD TCE-BL HORSESHOE 3017591 11001 BLVD TCE-BL DOWNTOWN 3012453 11002 BLVD TCE-BL DOWNTOWN 3007534 11003 BLVD TCE-BL DOWNTOWN 3010712 11004 BLVD TCE-BL DOWNTOWN 3002970 <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> </tbody>
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
0	0	0

<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" span="3"> <tbody> </tbody>

 

[DRSteele]

Welcome to the forum.

I think this might help. Copy the formula A4 across. Depending on your version of Excel, the formula in A4 might need to be invoked with Ctrl+Shift+Enter.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Book1
	A	B	C	D
1	11001	11002	11003	11003
2	BVLD TCE-BL	BVLD TCE-BL	BVLD TCE-BL	BVLD TCE-BL
3	HORSESHOE	DOWNTOWN	HORSESHOE	REACTIVE
4	not found	3007534	not found	not found
5
6	11037	BVLD TCE-BL	HORSESHOE	3017518
7	11041	BVLD TCE-BL	HORSESHOE	3002502
8	11045	BVLD TCE-BL	HORSESHOE	3017591
9	11001	BVLD TCE-BL	DOWNTOWN	3012453
10	11002	BVLD TCE-BL	DOWNTOWN	3007534
11	11003	BVLD TCE-BL	DOWNTOWN	3010712
12	11004	BVLD TCE-BL	DOWNTOWN	3002970
Sheet35

Cell Formulas
Range	Formula
A4	=IFNA(INDEX($D$6:$D$12,MATCH(A1&A2&A3,$A$6:$A$12&$B$6:$B$12&$C$6:$C$12,0)),"not found")

[/FONT]

 

[NSegna]

Thank you for your response,
Unfortunately, the formula gave me a #VALUE ! Error when I entered it on my spreadsheet. I then tried to recreate the sample you sent me and got the same error message on that too.

 

[Fluff]

Did you confirm it with Ctrl Shift Enter?
If so you should see the formula wrapped in {}