I'm sure you know what you mean by "not working", but your examples
still seem ambiguous to me.
Perhaps you should give an example of what you expect to see if
1) D10 and D11 are both blank
2) D10 is blank and D11 isn't
3) D10 isn't blank and D11 is
4) Both D10 and D11 are not blank
If what you want displayed in the cell depends on the result(s) of the
respective VLOOKUPs, be sure to include that information as well.
In article ,
operative Word wrote:
Thank you for your posting here is what I have so far but it is still not
working: =IF(D10="",IF(D11="","",VLOOKUP(D11,A323:F391,4)=" QM","Quality -
for QM Plant only"),VLOOKUP(D10,A228:D294,4)="QM","Quality - for QM Plant
only"))
the hold up is the two "look ups" using different cells and different cell
look ups, if that makes sence?
"JE McGimpsey" wrote:
One way (if I understand you correctly):
=IF(D10="",IF(D11="", "", VLOOKUP(D11,A323:F391,6)),
VLOOKUP(D10,A323:F391,6))
In article ,
operative Word <operative wrote:
I am trying to use a cell to show one of two different inputs from two
different cells into one using vlookup. I used 'or' did not work I used
:
=IF(D10="","",IF(D10="",(VLOOKUP(D10,A228:F320,6)) ,IF(D11="","",IF(D11,"",
(VLO
OKUP(D11,A323:F391,6))))))
excell accepted but it does not work. The cells d10 and d11 are
validation
cell with lists.