This is the formula I have used in cell E14 =IF(C14="In Stock", D14*VLOOKUP(B14,product_status,3, FALSE), "Coming soon.") We have also used another IF and VLOOKUP combo under the Price $ column. If this part of the formula returns a TRUE value then the cell will show “In Stock” value, otherwise it will show “Not in Stock” value. We are using this formula VLOOKUP(B14, product_status, 2, FALSE)="Available"as the IF function’s logical_test argument.
Let’s explain the logical_test argument of this formula. Here is the explanation for new Excel users: This formula is also self-explanatory from the above image. =IF(VLOOKUP(B14, product_status, 2, FALSE)="Available", "In Stock", "Not in Stock") How does this formula work? In the 2 nd table (under the Shopping Cart), under the Status column, and in cell C14 I have input this formula: The table lists some products and their status under the Availability column. In the following worksheet (top left corner), you’re seeing I have a table. This is a good example if you manage inventory using Excel.
#HOW DO YOU USE VLOOKUP IN EXCEL 2016 HOW TO#
In this example, you will see how to use two or more table arrays in the Excel VLOOKUP formula. VLOOKUP finds the value of the F8 cell in the shop_price table array and if it finds then returns the value of the 3 rd column of the same row.
1) Using VLOOKUP and IF condition to Choose the best Bargain Store