Multiple lookup

G

gsizelove

New Member
Joined
Nov 15, 2010
Messages
31
I'm trying to create a formula that will return a result based on several lookup criteria. There are two sheets in my file. The first contains the lookup criteria and the second includes the data that I want to find. A subsection of the data on the second tab is below.

I want a formula to lookup the following information on the first tab:
B36 will be the value that is looked up in row 1 of the data set
AA2 will be the value that is looked up in row 2 of the data set
B5 will be the value that is looked up in column G of the data set
B6 will be the value that is looked up in column H of the data set

[TABLE="width: 1029"]
<tbody>[TR]
[TD]
[TABLE="width: 1258"]
<colgroup><col span="17"></colgroup><tbody>[TR]
[TD]COLUMN G[/TD]
[TD]COLUMN H[/TD]
[TD]COLUMN I[/TD]
[TD]COLUMN J[/TD]
[TD]COLUMN K[/TD]
[TD]COLUMN L[/TD]
[TD]COLUMN M[/TD]
[TD]COLUMN N[/TD]
[TD]COLUMN O[/TD]
[TD]COLUMN P[/TD]
[TD]COLUMN Q[/TD]
[TD]COLUMN R[/TD]
[TD]COLUMN S[/TD]
[TD]COLUMN T[/TD]
[TD]COLUMN U[/TD]
[TD]COLUMN V[/TD]
[TD]COLUMN W[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]B [/TD]
[TD]B [/TD]
[TD]B [/TD]
[TD]B [/TD]
[TD]B [/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]1[/TD]
[TD]$1.00[/TD]
[TD]$2.00[/TD]
[TD]$3.00[/TD]
[TD]$4.00[/TD]
[TD]$5.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]2[/TD]
[TD]$10.00[/TD]
[TD]$11.00[/TD]
[TD]$12.00[/TD]
[TD]$13.00[/TD]
[TD]$14.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]3[/TD]
[TD]$20.00[/TD]
[TD]$21.00[/TD]
[TD]$22.00[/TD]
[TD]$23.00[/TD]
[TD]$24.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]4[/TD]
[TD]$30.00[/TD]
[TD]$31.00[/TD]
[TD]$32.00[/TD]
[TD]$33.00[/TD]
[TD]$34.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]1[/TD]
[TD]$40.00[/TD]
[TD]$41.00[/TD]
[TD]$42.00[/TD]
[TD]$43.00[/TD]
[TD]$44.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]2[/TD]
[TD]$50.00[/TD]
[TD]$51.00[/TD]
[TD]$52.00[/TD]
[TD]$53.00[/TD]
[TD]$54.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]3[/TD]
[TD]$60.00[/TD]
[TD]$61.00[/TD]
[TD]$62.00[/TD]
[TD]$63.00[/TD]
[TD]$64.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]4[/TD]
[TD]$70.00[/TD]
[TD]$71.00[/TD]
[TD]$72.00[/TD]
[TD]$73.00[/TD]
[TD]$74.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]For example, if the criteria below are entered the result would be $50.00.

B36 = A
AA2 = U
B5 = G
B6 = 2
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
Is this possible?

Thanks
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Let data house the data...

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
G​
[/td][td]
H​
[/td][td]
I​
[/td][td]
J​
[/td][td]
K​
[/td][td]
L​
[/td][td]
M​
[/td][td]
N​
[/td][td]
O​
[/td][td]
P​
[/td][td]
Q​
[/td][td]
R​
[/td][td]
S​
[/td][td]
T​
[/td][td]
U​
[/td][td]
V​
[/td][td]
W​
[/td][/tr]
[tr][td]
1​
[/td][td][/td][td][/td][td]A[/td][td]A[/td][td]A[/td][td]A[/td][td]A[/td][td]B[/td][td]B[/td][td]B[/td][td]B[/td][td]B[/td][td]C[/td][td]C[/td][td]C[/td][td]C[/td][td]C[/td][/tr]

[tr][td]
2​
[/td][td][/td][td][/td][td]U[/td][td]V[/td][td]X[/td][td]Y[/td][td]Z[/td][td]U[/td][td]V[/td][td]X[/td][td]Y[/td][td]Z[/td][td]U[/td][td]V[/td][td]X[/td][td]Y[/td][td]Z[/td][/tr]

[tr][td]
3​
[/td][td]M[/td][td]
1​
[/td][td]
$1.00​
[/td][td]
$2.00​
[/td][td]
$3.00​
[/td][td]
$4.00​
[/td][td]
$5.00​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
4​
[/td][td]M[/td][td]
2​
[/td][td]
$10.00​
[/td][td]
$11.00​
[/td][td]
$12.00​
[/td][td]
$13.00​
[/td][td]
$14.00​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
5​
[/td][td]M[/td][td]
3​
[/td][td]
$20.00​
[/td][td]
$21.00​
[/td][td]
$22.00​
[/td][td]
$23.00​
[/td][td]
$24.00​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
6​
[/td][td]M[/td][td]
4​
[/td][td]
$30.00​
[/td][td]
$31.00​
[/td][td]
$32.00​
[/td][td]
$33.00​
[/td][td]
$34.00​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
7​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
8​
[/td][td]G[/td][td]
1​
[/td][td]
$40.00​
[/td][td]
$41.00​
[/td][td]
$42.00​
[/td][td]
$43.00​
[/td][td]
$44.00​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
9​
[/td][td]G[/td][td]
2​
[/td][td]
$50.00​
[/td][td]
$51.00​
[/td][td]
$52.00​
[/td][td]
$53.00​
[/td][td]
$54.00​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
10​
[/td][td]G[/td][td]
3​
[/td][td]
$60.00​
[/td][td]
$61.00​
[/td][td]
$62.00​
[/td][td]
$63.00​
[/td][td]
$64.00​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
11​
[/td][td]G[/td][td]
4​
[/td][td]
$70.00​
[/td][td]
$71.00​
[/td][td]
$72.00​
[/td][td]
$73.00​
[/td][td]
$74.00​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

In the processing sheet which houses the look up values, control+shift+enter, not just enter:
Rich (BB code): 

=INDEX(data!$I$3:$W$11,
    MATCH(1,IF(data!$G$3:$G$11=B5,IF(data!$H$3:$H$11=B6,1)),0),
    MATCH(1,IF(data!$I$1:$W$1=B36,IF(data!$I$2:$W$2=AA2,1)),0))
 
Upvote 0
A typo I think.

AU2 instead.

Howard

Code: 
=INDEX(data!$I$3:$W$11,
    MATCH(1,IF(data!$G$3:$G$11=B5,IF(data!$H$3:$H$11=B6,1)),0),
    MATCH(1,IF(data!$I$1:$W$1=B36,IF(data!$I$2:$W$2=[COLOR="#FF0000"]AA2[/COLOR],1)),0))
 
Upvote 0
Aladin Akyurek said:
Let data house the data...

[TABLE="class: grid"]
<tbody>[TR]
[TD]Row\Col[/TD]
[TD]
G​
[/TD]
[TD]
H​
[/TD]
[TD]
I​
[/TD]
[TD]
J​
[/TD]
[TD]
K​
[/TD]
[TD]
L​
[/TD]
[TD]
M​
[/TD]
[TD]
N​
[/TD]
[TD]
O​
[/TD]
[TD]
P​
[/TD]
[TD]
Q​
[/TD]
[TD]
R​
[/TD]
[TD]
S​
[/TD]
[TD]
T​
[/TD]
[TD]
U​
[/TD]
[TD]
V​
[/TD]
[TD]
W​
[/TD]
[/TR]
[TR]
[TD]
1​
[/TD]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]
2​
[/TD]
[TD][/TD]
[TD][/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]
3​
[/TD]
[TD]M[/TD]
[TD]
1​
[/TD]
[TD]
$1.00​
[/TD]
[TD]
$2.00​
[/TD]
[TD]
$3.00​
[/TD]
[TD]
$4.00​
[/TD]
[TD]
$5.00​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
4​
[/TD]
[TD]M[/TD]
[TD]
2​
[/TD]
[TD]
$10.00​
[/TD]
[TD]
$11.00​
[/TD]
[TD]
$12.00​
[/TD]
[TD]
$13.00​
[/TD]
[TD]
$14.00​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
5​
[/TD]
[TD]M[/TD]
[TD]
3​
[/TD]
[TD]
$20.00​
[/TD]
[TD]
$21.00​
[/TD]
[TD]
$22.00​
[/TD]
[TD]
$23.00​
[/TD]
[TD]
$24.00​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
6​
[/TD]
[TD]M[/TD]
[TD]
4​
[/TD]
[TD]
$30.00​
[/TD]
[TD]
$31.00​
[/TD]
[TD]
$32.00​
[/TD]
[TD]
$33.00​
[/TD]
[TD]
$34.00​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
7​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
8​
[/TD]
[TD]G[/TD]
[TD]
1​
[/TD]
[TD]
$40.00​
[/TD]
[TD]
$41.00​
[/TD]
[TD]
$42.00​
[/TD]
[TD]
$43.00​
[/TD]
[TD]
$44.00​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
9​
[/TD]
[TD]G[/TD]
[TD]
2​
[/TD]
[TD]
$50.00​
[/TD]
[TD]
$51.00​
[/TD]
[TD]
$52.00​
[/TD]
[TD]
$53.00​
[/TD]
[TD]
$54.00​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
10​
[/TD]
[TD]G[/TD]
[TD]
3​
[/TD]
[TD]
$60.00​
[/TD]
[TD]
$61.00​
[/TD]
[TD]
$62.00​
[/TD]
[TD]
$63.00​
[/TD]
[TD]
$64.00​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
11​
[/TD]
[TD]G[/TD]
[TD]
4​
[/TD]
[TD]
$70.00​
[/TD]
[TD]
$71.00​
[/TD]
[TD]
$72.00​
[/TD]
[TD]
$73.00​
[/TD]
[TD]
$74.00​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


In the processing sheet which houses the look up values, control+shift+enter, not just enter:
Rich (BB code): 

=INDEX(data!$I$3:$W$11,
    MATCH(1,IF(data!$G$3:$G$11=B5,IF(data!$H$3:$H$11=B6,1)),0),
    MATCH(1,IF(data!$I$1:$W$1=B36,IF(data!$I$2:$W$2=AA2,1)),0))
Click to expand...


That worked perfectly. Thanks so much!!
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Assistance with Index Match formula
Replies
2
Views
181
Jay88
J
B
  • Solved
lookup formula with 3 variables to calculate
Replies
8
Views
199
bh24524
B
K
  • Question Question
conditional formatting question
Replies
2
Views
564
kerm007
K
P
  • Question Question
Creating Sub Totals for a Sort, Unique, Filter, Choose Cols dynamically
Replies
6
Views
299
ExcelToDAX
E
B
  • Question Question
VBA to Insert Column, Lookup to another workbook, return results.
Replies
1
Views
197
dermie_72
D

Forum statistics

Threads
1,223,262
Messages
6,171,080
Members
452,377
Latest member
bradfordsam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top