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 |