#N/A Issues... Needing Help...

[lonnie451]

If there is nothing in cells B11 and C11, I want F11 to be Blank.

Book3
	B	C	D	E	F	G
9	Product	Qty		Description	Price	Total
10	Bananas	3LB			2.45
11					#N/A
12					#N/A
13					#N/A
14					#N/A
15					#N/A
16					#N/A
Sheet1

Cell Formulas
Range	Formula
F10:F16	F10	=VLOOKUP(B10,Sheet2!$A$4:$D$6,MATCH(Sheet1!C10,Sheet2!$B$3:$D$3,0)+1,FALSE)

Cells with Data Validation
Cell	Allow	Criteria
B10:B16	List	=Sheet2!$A$4:$A$6
C10:D16	List	=Sheet2!$B$3:$D$3

 

[Eric W]

Try:

=IFERROR(VLOOKUP(B10,Sheet2!$A$4:$D$6,MATCH(Sheet1!C10,Sheet2!$B$3:$D$3,0)+1,FALSE),"")

 

[lonnie451]

Try:

=IFERROR(VLOOKUP(B10,Sheet2!$A$4:$D$6,MATCH(Sheet1!C10,Sheet2!$B$3:$D$3,0)+1,FALSE),"")

TY.. That was a Life saver.. been racking my brains on that one...

 

[Eric W]

Happy to help! It's sometimes tough to keep track of all the functions. Thanks for the feedback.