-
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. SKU
- table array = Where are you looking?
- Ex. UPC spreadsheet
- column index = What do you want to return?
- Ex. "3" for 3rd column that has UPC numbers
- FALSE=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.
|
|
