# Excel Formulas

 What is Vlookup used for? -when you want to lookup and retrieve data from multiple spreadsheet-for example if i need UPCs in a new product template im working one Vlookup formula =VLOOKUP(lookup value, table array, column index, FALSE) lookup value = what are you looking for? Ex. SKUtable array = Where are you looking?Ex. UPC spreadsheetcolumn index = What do you want to return?Ex. "3" for 3rd column that has UPC numbersFALSE=exact match of what i want returned Formula counts the number of characters in a cell =LEN(A1) Used this for ebay title updated, needed to know the characters to optimize our titles IF statement formula that says: “IF the salesperson met their quota, say “Met quota”, if not say “Did not meet quota” IF(C3>D3, “Met Quota”, “Did Not Meet Quota”) Formula if you need to combine data into one cell. =CONCATENATE(A1," ",B2) Formula to output the largest numerical value in the rows =MAX(A1:A10) INDEX & MATCH FORMULA =INDEX(B2:F5,MATCH(D8,A2:A5,0),MATCH(D9,B1:F1,0)) -cross match what a particular SKU sold for a given month IF Formula where i compared our MAP with Wayfair MAP =IF(A2=B2,"Match","Break") -Ex. Match MAP with Wayfair MAP to find if there are any violations Formula where i compare our inventory export with channel export to see what SKU is missing on the channel =COUNTIF(Sheet2!A:A,A2)>0 A:A is the column list you check value in, and B2 is the value you want to find if is in the list. Authordante01 ID348068 Card SetExcel Formulas DescriptionExcel Updated2019-08-02T06:57:26Z Show Answers