Forum Discussion
Creating a IF, Then And formula
Im trying to create a formula that has multiple variables, I have 2 cells( A2 and B2), A2 can have different variables, for example A2 can = 100 or 200 or 300 or 400 or 500, Cell B2 must then change ...
=VLOOKUP(A2,{100,200;200,300;300,400;400,500;500,6000},2,0)