Lookup Help

[MIVELD]

Trying to create a standard VLOOKUP, however i want a cell value to stipulate the range i a VLOOKUPing against

ie: =VLOOKUP(A5,"Cell C2 Value",2,0)

The user will change Cell C2 on a dropdown list and this should then change the range the lookup is pointing to

Please help ripping my hair out

[daddylonglegs]

You can use INDIRECT, assuming C2 contains any valid range, e.g. F2:G10 then use

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

[MIVELD]

You are a SuperStar

Appreciate the help