variable cell location for VLOOKUP

**kerradeph** · 05-27-2013, 12:55 PM

so I'm trying to get a VLOOKUP search to work, I've got it working just fine using manual input of the table placement, but I want to be able to have some cells with the table size or locations in them so I can change that and have the entire table change at once.

right now I've got
=VLOOKUP(B4,'LP mod cost'!C$2:Y$50,23,FALSE)
and that works just fine, but now I'm trying to use indirect to point to 2 cells that would direct to C2 and Y50, and that seems to be causing issues.
=VLOOKUP(B2,'LP mod cost'!(INDIRECT(P2))

INDIRECT(P3)),23,FALSE)
I've been working on this while a bit sleep deprived so I might be missing something really simple, but right now it's just confusing me.

I've attached the file I'm working on (or at least I think I have, it's just hanging there and the page is not responding) so that you can see what I'm doing. I've got 3 sheets grabbing information from XMLs off a web server, and that's the information I'm trying to reference.

EDIT: damn smilies. that's supposed to be VLOOKUP(B2,'LP mod cost'!(INDIRECT(P2)) : (INDIRECT(P3)),23,FALSE) without the spaces between the indirect functions and the colon.

**FDibbins** · 05-27-2013, 12:59 PM

Hi and welcome to the forum

you were almost there.....
=VLOOKUP(B2,INDIRECT("'LP mod cost'!"&P2&":"&P3),23,FALSE)

**kerradeph** · 05-27-2013, 01:15 PM

wow, that's quick. thank you. I've never used either of those functions before, so I was somewhat blindly stumbling around trying to get them to work. I more or less figured out VLOOKUP, but I'd never even seen indirect until it was suggested for what I was trying to do.