VLOOKUP G5 IF F5New new_customer old_customer 2 TRUE G5 is the lookup_value here and it is an amount under the Sales column. For this to work we need to set the last argument in the vlookup range_lookup to TRUE. An Excelchat Expert solved this problem in 20 mins.
In order to test the VLOOKUP formula were about to write we first enter a valid item code into cell A11 of our blank invoice.
The column number in the range that contains the return value. With the last argument set to TRUE vlookup will find the closest match to the lookup value that is less than or equal to the lookup amount. We get a new function window showing in the below mention pictures. Go back to the Report tab Go to cell B3 and key the formula VLOOKUP A3FlaggedAE50 Copy the formula down the report Add a filter to row headers Go to column B and filter on Yes.