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

Honor 9 Lite review

How Sam Falconer transforms science and geology into digestible, elegant illustrations

HomePod review

Les meilleures séries Netflix (2018)