Use cell value in vlookup formula

=vlookup(c2,code1,2,false)

I am using the vlookup code but I would like to use the cell value in 'c2' rather than c2 itself. The value within this cell will change, at the moment it is 'aj2'. Is there an easy way of doing this?

Hi Thanks, that doesn't seem to work for what I want. I suppose it might be easier if I explain what I want to do eventually. I would like to be able to type in a column reference i.e. B (excluding the cell 开发者_如何学编程row).

Sheet1 (Input column reference)

A-B

Code1-B (this cell value will change)

Sheet2 (Name reference 'code1')

A-B

Pre Start -1

Established-2

Sheet3 (Data pasted from another file-this data will change)

A-B-C

1-Pre Start- =vlookup (Show '1' from the code1) 2-Established- =vlookup (Show '2' from the code1)

3-Established- =vlookup (Show '2' from the code1)

4-Pre Start- =vlookup (Show '1' from the code1) 5-Pre Start- =vlookup (Show '1' from the code1)

=VLOOKUP(INDIRECT(c2),code1,2,false)

You could use =INDIRECT:

=VLOOKUP(INDIRECT(C2), code1, 2, FALSE)

Here you miss INDIRECT:- You Can use this and may help you

=VLOOKUP(INDIRECT(C2), code1, 2, 0)