So, the VLOOKUP function will return the value from the 2 nd column of the same row where it finds the lookup value. IF(F5="New", new_customer, old_customer): This formula will return one of the two tables: new_customer and old_customer.G5 is the lookup_value here and it is an amount under the Sales column.In cell H5, I have used this formula: =VLOOKUP(G5, IF(F5="New", new_customer, old_customer), 2, TRUE).Here is the explanation for the complete laymen: In the following image, you’re seeing how I have made a formula using VLOOKUP and IF functions to choose one of the two table arrays. 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. If the logical test is FALSE, then it returns this part of the formula VLOOKUP(F8, shop_price,3, FALSE).It searches for the value of cell F8 in the shop_price table array and if it finds there then returns the value of the 2 nd column of the same row. If the above logical test is TRUE, it returns this part of the formula VLOOKUP(F8, shop_price,2, FALSE).IF Function tests whether $C$4 cell value is equal to value Meena.Let me explain the formula in cell G8 = IF($C$4="Meena",VLOOKUP(F8,shop_price,2,FALSE),VLOOKUP(F8,shop_price,3,FALSE)) 1) Using VLOOKUP and IF condition to Choose the best Bargain Store
0 kommentar(er)
