View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norbert[_4_] Norbert[_4_] is offline
external usenet poster
 
Posts: 52
Default Problem with hlookup formula

On Wednesday, 9 December 2020 at 13:36:12 UTC+2, Adrian Caspersz wrote:
On 09/12/2020 11:27, Norbert wrote:
Hi,
how can I get the value of the neighbouring cell of the cell which is found by
a hlookup formula returned.
E.g: my hlookup formula finds the cell C372 but I want the value of D372

You need the OFFSET function

--
Adrian C


Thanks Adrian! Never used Offset before, but it makes sense. Cool!