Thread: Problem with hlookup formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Adrian Caspersz Adrian Caspersz is offline
external usenet poster
  
Posts: 19
Default Problem with hlookup formula
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
Reply With QuoteReply With Quote