Hlookup extension

A

Anto111

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
 
P

Pete_UK

Try this:

=INDEX($D$3:BC$3,MATCH($B$36,$D$2:BB$2,0)+1))

You had some typos on your range, but I think I have deduced them
correctly.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMPLICATED FORMULA WITH EMBEDDED HLOOKUP 2
HLOOKUP with variable rows 3
Hlookup function 1
Hlookup 0
Lookup Value 2
Vlookup Vertically 4
IF, AND Formula 1
#VALUE error which disappears when I use F2, ENTER 1

Top