how do I change CONCATENATE result to a formula

[Mecha04]

This is my first phone so I hope this is clear for you

I created the following result using CONCATENATE;


=vlookup(316692,'[40603.xlsx]extract!$C$2:$H$1000,2,FALSE)

(FYI, the formula works when I enter it as a vlookup formula)

but I want to link to it from a different cell and run it as a formula. Any ideas? Thanks

I used CONCATENATE because the first two numbers in the VLOOKUP will change on each line and I do not want to enter the VLOOKUP everytime.

 

[Roseus]

Instead of concatenating the first two numbers, is it possible to just refer to the cells themselves?

If not, can you post the formula you're using to concatenate? More details might help to better assist you

 

[Smitty]

Welcome to the Board!

This is my first phone so I hope this is clear for you

Thanks for leaving a message!

Seriously though, I'm not sure what you mean by creating a vlookup from concatenate - Is the 316692 the result of your concatenation?

If you want the 316692 to be a cell reference instead of a hard value, just refer to that cell:

=VLOOKUP(A1,'[40603.xlsx]extract!$C$2:$H$1000,2,FALSE)

Where A1 holds the concatenated reference.

Note with concatenated references you can also skip the middle man and just go direct:

=VLOOKUP(A1&B1,'[40603.xlsx]extract!$C$2:$H$1000,2,FALSE)

HTH,

 

[jasonb75]

By 'First two numbers do you mean'

=vlookup(316692,'[40603.xlsx]extract!$C$2:$H$1000,2,FALSE)

If so something like

=VLOOKUP(A1,INDIRECT("'["&B1&".xlsx]extract'!$C$2:$H$1000"),2,FALSE)

will be what you need.