I have a workbook with 2 sheets, in sheet 2 are a list of product codes with corresponding price in 2 currencies. In sheet 1 a drop-down list of the product codes and a drop-down list of the 2 currencies.
As it is now, in sheet 1, I select the product code from a list and with the below formula I am only able to pull the “USD List” price regardless if I select “USD List” or “CAD List” because I don’t know how to write the formula to identify where to draw the data from.
=IF(ISNA(VLOOKUP(A2,'Sheet 2'!$B$2:$C$4,2,FALSE)),"",VLOOKUP(A2,'Sheet 2'!$B$2:$C$4,2,FALSE))
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
<thead>
</thead><tbody>
</tbody>
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
<thead>
</thead><tbody>
</tbody>
As it is now, in sheet 1, I select the product code from a list and with the below formula I am only able to pull the “USD List” price regardless if I select “USD List” or “CAD List” because I don’t know how to write the formula to identify where to draw the data from.
=IF(ISNA(VLOOKUP(A2,'Sheet 2'!$B$2:$C$4,2,FALSE)),"",VLOOKUP(A2,'Sheet 2'!$B$2:$C$4,2,FALSE))
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
SHEET 1 | |||
---|---|---|---|
A | B | C | |
1 | Product Code | Currency | Price |
2 | VB-444x612-2 | CAD List | $10.00 |
3 | MM-898x728-3 | USD List | $15.00 |
4 |
<thead>
</thead><tbody>
</tbody>
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
SHEET 2 | |||
---|---|---|---|
A | B | C | |
1 | Product Code | USD List | CAD List |
2 | VB-444x612-2 | $10.00 | $11.00 |
3 | MM-898x728-3 | $15.00 | $16.00 |
4 | MS-999x2142-1S | $12.00 | $13.00 |
<thead>
</thead><tbody>
</tbody>