View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Concat a parameter into a vlookup?

Yes.

Look in HELP for the INDIRECT() function

Post again in this same thread if you can't get it done

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Stephen" wrote in message ...
| Is is possible to say
|
| =IF(ISNA(VLOOKUP($X996,Weights.xls!w"VALUE IN CELL C5"s,3,FALSE))
|
| ?