G
Guest
I want to do a vlookup based on a range that is based on a cell.
So, if cell A1 = "CA" use the CA_REG named range in my formula.
If cell A1 = "NV" use the NV_REG named range in my formula.
etc. etc.
There will be about a dozen values that the cell can have, so I can't use a
nested if.
Any ideas?
So, if cell A1 = "CA" use the CA_REG named range in my formula.
If cell A1 = "NV" use the NV_REG named range in my formula.
etc. etc.
There will be about a dozen values that the cell can have, so I can't use a
nested if.
Any ideas?