Originally Posted by
JohnTopley
It really would help if you posted a small file showing expected outcomes.
... and indeed the precise rule
@pingman3
Are you saying that the rule is always
If A1 = 1 then return the value 3
If A1 = 2 then return the value 5
If A1 = 3 then return the value 4
If A1 = 4 then return the value 1
If A1 = 5 then return the value 2
that's ok for the five items you specifically show but the implication in your first post is that A1 might have other values like 6 or 7 ...and are there others.
If the mapping above is all you need then just create a Vlookup table with the values 1-5 in the first column and the values 3,5,4,1,2 in the second column. Then the VLOOKUP would be assuming the table is in say C1:D5
Bookmarks