View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anto111 Anto111 is offline
external usenet poster
 
Posts: 41
Default Hlookup extension

Hi Guys,

I am currently using the formula: =Hlookup($B$36,$D$2:BB:42,2,False). What I
need to add however is something that will return the corresponding value one
column to the right of the current specified value

So for example find the word "dog" in row 2 and return the value 1 row
below and one column to the right.

All help would again be very warmly appreciated.

Many thanks in advance.

Ant