Excel - Inserting a variable in VLOOKUP

  howryou 17:21 16 May 2008

Starting with =VLOOKUP(G8,XXXXX,N5,FALSE)/100, where XXXXX is the name of the range, which is the result of a concatenation of "Year", the contents of Cell M5 & the contents of Cell O5
=CONCATENATE("Year",M5,O5) - can it be done?

  VoG II 17:30 16 May 2008

What would you expect XXXXX to evaluate to?

  VoG II 10:38 17 May 2008

Let us assume that you want the equivalent of


M5 houses A1

O5 houses C20



  howryou 08:58 20 May 2008

Apologies - away for the weekend!

The XXXXX would be created from =CONCATENATE("Year",M5,O5) and this would generate a number of possibilities from "YearA4" to "YearA9" and "YearB1" to "YearB9", each of which are already defined Names/Areas.

How would you effectively get the Concatenation into the VLOOKUP


  VoG II 09:15 20 May 2008

Untested but try


  howryou 10:20 20 May 2008

Certainly works for me - Many thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?