Thank you, taking your example I waass able to get it to work.

=IF(D10="",IF(D11="",VLOOKUP(D11,A323:F391,4)="QM" ,"Quality - for QM Plant
only"),IF(VLOOKUP(D10,A228:D294,4)="QM","Quality - for QM Plant only",""))

Cell A15, requires blank when d10 and d11 are blank ( at present the field
A15 reads N/A)

A15 populates when either D10 or D11 are populated with the required values.
Both populated should give an error which is okay because both cells have
different values. and selections are independent from each other.

"JE McGimpsey" wrote:

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.