Hlookup Match function not working

[missmea2005]

Hi All,

I'm trying to get a nested H lookup to function and it isn't working. Here's what I'm trying to accomplish:

a) I have a formula that returns a name
b) I would like my formula to search a range for the row that contains that cell
c) Then search row A for the 2nd detail and return the corresponding cell for both

This is what I have

Please Login or Register  to view this content.

The code is searching from the attachment
legal.jpg


This is the array

array.jpg

[missmea2005]

Never mind problem solved! For anyone else who has the problem my Match was searching the entire array instead of the row :-/

[JohnTopley]

Removed by JT as problem solved!!