VLOOKUP issue

[mwvirk]

I am trying to use VLOOKUP and apply the same formula in 3 different cells but only 1 returns the result. what could be the issue?

MMK Clients Data.xlsx
	U
1
2	Mike
3
Commission

Cell Formulas
Range	Formula
U1	U1	=IFERROR(VLOOKUP(A1,'Members Status'!A:Z,3,0),"")
U2	U2	=IFERROR(VLOOKUP(A1,'Verify Accounts'!A:Z,3,0),"")
U3	U3	=IFERROR(VLOOKUP(A1,Confirmed!A:Z,3,0),"")

Named Ranges
Name	Refers To	Cells
Confirmed!_FilterDatabase	=Confirmed!$A$1:$Q$1	U3
'Members Status'!_FilterDatabase	='Members Status'!$A$1:$P$1	U1

 

[etaf]

cannot see from the info provided
you are looking in column A for a match on 3 different sheets
and then if there is a match , return the value in column C

so
=IFERROR(VLOOKUP(A1,'Verify Accounts'!A:Z,3,0),"")
returns mike
check that the value in A1 , also exits in column A on the other sheets
no spaces before or after

 

[myall_blues]

Since your formulas are wrapped in IFERROR, and the IFERROR is set to return blank if there is an error, it seems likely that the formulas in U1 and U3 are returning errors. Try removing the IFERROR part and see what happens.

 

[mwvirk]

@efat
@myall_blues
check now, please

MMK Clients Data.xlsx
	U	V
1	#N/A	value of A1 available in cell B77 for this sheet
2	Mike	value of A1 available in cell A4 for this sheet
3	#N/A	value of A1 available in cell D68 & O68 for this sheet
Commission

Cell Formulas
Range	Formula
U1	U1	=VLOOKUP(A1,'Members Status'!A:Z,3,0)
U2	U2	=VLOOKUP(A1,'Verify Accounts'!A:Z,3,0)
U3	U3	=VLOOKUP(A1,Confirmed!A:Z,3,0)

Named Ranges
Name	Refers To	Cells
Confirmed!_FilterDatabase	=Confirmed!$A$1:$Q$1	U3
'Members Status'!_FilterDatabase	='Members Status'!$A$1:$P$1	U1

 

[mwvirk]

removed 1
help to check these 2 only please

MMK Clients Data.xlsx
	U	V
1	#N/A	value of A1 available in cell B77 for this sheet
2	Mike	value of A1 available in cell A4 for this sheet
Commission

Cell Formulas
Range	Formula
U1	U1	=VLOOKUP(A1,'Members Status'!A:Z,3,0)
U2	U2	=VLOOKUP(A1,'Verify Accounts'!A:Z,3,0)

Named Ranges
Name	Refers To	Cells
'Members Status'!_FilterDatabase	='Members Status'!$A$1:$P$1	U1

 

[etaf]

vlookup only looks in column A based on how you have written it NOT column B or D or O

 

[etaf]

what column do you want to return for this formula
=VLOOKUP(A1,'Members Status'!A:Z,3,0)

you need to change to look in column B
=VLOOKUP(A1,'Members Status'!B:Z,3,0)
will return column D as has a 3 , so 3 columns from B including B

But maybe better to describe what you are trying to do with full details for each formula

 

[mwvirk]

what column do you want to return for this formula
=VLOOKUP(A1,'Members Status'!A:Z,3,0)

you need to change to look in column B
=VLOOKUP(A1,'Members Status'!B:Z,3,0)
will return column D as has a 3 , so 3 columns from B including B

But maybe better to describe what you are trying to do with full details for each formula

thank you
this resolved the problem
=VLOOKUP(A1,'Members Status'!B:Z,3,0)

 

[etaf]

you are welcome