I have a userform that populates a value in column D. What I'm trying to get it to do when the OK button is clicked is to have a vlookup the value in that column. But it needs to perform a different lookup based on the value.
So if Cell D8 value = 1 then cell F8 lookup formula would be...