vhlookup or cell to cell corelation

[happychronicles]

Hi,

I have a list of data that correlates with each other.
I need to be able to do an =A!:A150, if true then this cells = X

Bl	T	No.
1	3	1
1	1	2
1	4	3
1	2	4
2	2	5
2	3	6
2	1	7
2	4	8

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

BL	t	No
1	=3	1
1	=3	1

<tbody>
</tbody>

Any Help would be much appriciated.
Thank you, Jess

 

[Marcílio_Lobão]

Jess, Good evening.

"...I need to be able to do an =A!:A150..."
What is this???

Scenario:

	A	B	C	D	E	F	G
1	BL	T	No.		BL	T	Nº
2	1	3	1		1	4	=formula
3	1	1	2
4	1	4	3
5	1	2	4
6	2	2	5
7	2	3	6
8	2	1	7
9	2	4	8

<tbody>
</tbody>

Try to use:

=SUMPRODUCT((A2:A9=E2) * (B2:B9=F2) * (C2:C9))

Is that what you want?
I hope it helps.

 

[happychronicles]

A	B	C	D	E	F	G	H	I	G
Table 1					Table 2
BL	T	N			BL	T	N
1	3	4			1	(Should be 3)	(should be 4)
2	4	5			1	should be 3	should be 4
3	6	6			2	Should be 4	Should be 5
4	4	7			2	should be 4	should be 5
5	4	8			2	should be 4	should be 5

<tbody>
</tbody>

Hi I hope that this helps clear up what I am looking for.
Thank you for your time and sorry for not making myself clear.

 

[happychronicles]

Hi, That isn't what I am looking for. I will try to make my question more coherent.

A	B	C
BL	T	NO.
1	2	4
2	1	5
3	3	6
4	4	7

<tbody>
</tbody>

TABLE 2
A	B	C
BL	T	NO.
1	SHOULD =2	SHOULD =4
1	SHOULD =2	SHOULD = 4
1	SHOULD = 2	SHOULD = 4
3	SHOULD =3	SHOULD = 6
3	SHOULD =3	SHOULD -6
3	SHOULD = 3	SHOULD =6
4	SHOULD =4	SHOULD = 7

<tbody>
</tbody>

I would like to have a formula for table two for columns B and C that are drived from table one based on column A in table 1.
Thank you for your time.

 

[Marcílio_Lobão]

Jess,

Now your original table is very different from your first message.

Then the logic will be different and much simple.

	A	B	C
1	BL	T	No.
2	1	2	4
3	2	1	5
4	3	3	6
5	4	4	7

<tbody>
</tbody>

	A	B	C
40	BL	T	No.
41	1	=formula	=formula
42	1
43	3
44	4

<tbody>
</tbody>

Try this one:

B41 --> =VLOOKUP(A41, $A$2:$C$5, 2, false)

C41 --> =VLOOKUP(A41, $A$2:$C$5, 3, false)

Copy the formulas down.

Adapt cell reference to your reality.

Is that what you want?
I hope it helps.

 

[happychronicles]

I will try this!
Thank you for your response!