Hi
I am trying to do a vlookup, but the value I want to return is to the left of the table array. I can see the obvious problem that a VLOOKUP looks for a match in the first column of the defined range - but I was wondering if there was any way around this?
In case I haven't explained this very well (or incase there is an alternative solution not using VLOOKUP), what I am trying to do is:
I want to look at the value in cell C5. If it is a "1", I want "TRA" to appear in cell AC5. If it is a "2", I want "DUO" to appear in cell AC5. If it is a "3" I want "AZA" to appear in AC5. If it is a "4", I want "SYS" to appear in AC5.
Currently, the TRA, DUO, AZA, SYS are in the range B5:B8, hence the question about whether
would work. Any help would be greatly appreciated,
Rich
I am trying to do a vlookup, but the value I want to return is to the left of the table array. I can see the obvious problem that a VLOOKUP looks for a match in the first column of the defined range - but I was wondering if there was any way around this?
In case I haven't explained this very well (or incase there is an alternative solution not using VLOOKUP), what I am trying to do is:
I want to look at the value in cell C5. If it is a "1", I want "TRA" to appear in cell AC5. If it is a "2", I want "DUO" to appear in cell AC5. If it is a "3" I want "AZA" to appear in AC5. If it is a "4", I want "SYS" to appear in AC5.
Currently, the TRA, DUO, AZA, SYS are in the range B5:B8, hence the question about whether
Code:
=VLOOKUP(C5,C5:C8,-1,FALSE)
would work. Any help would be greatly appreciated,
Rich