Hi how can I use VLOOKUP (or another search formula if needed) using a cell that contains a formula ? This formula is in Cell A5... I am running a VLOOKUP , my look up value is a number that is derived from the output of a formula . For some reason the VLOOKUP does not work when the look up value is derived this way. if I manually type in the number it works. I was wondering if it is possible to do a VLOOKUP where the lookup_value can be more than one value. I tried using an OR function but that didnt seem to... I created a VLOOKUP table on another sheet, convert, in the workbook. I created the following formula , = VLOOKUP (C9,convert!A2:B452,2,) But when I try to replicate down to the next cell in the column, the C9 increases to C10, which is expected, but the range of the VLOOKUP also increases to...
