Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How would I use one cell to look at two different vlookups?
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,"",(VLOOKUP(D11,A323:F391,6)) )))) excell accepted but it does not work. The cells d10 and d11 are validation cell with lists. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How would I use one cell to look at two different vlookups?
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How would I use one cell to look at two different vlookups?
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How would I use one cell to look at two different vlookups?
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How would I use one cell to look at two different vlookups?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookups | Excel Worksheet Functions | |||
vlookups | Excel Discussion (Misc queries) | |||
Vlookups | Excel Discussion (Misc queries) | |||
vlookups | Excel Worksheet Functions | |||
Vlookups | Excel Worksheet Functions |