HLookup function question

[Cam]

Hello,

Can you look up more than 4 columns of information in the
HLOOKUP function? For Example:
=HLOOKUP(PartNbr!$B$16,A16:H18,2) 7 columns

I tried and it doesn't work if more than 4 columns. Is
there another way to make this work? Thanks

 

[Trevor Shuttleworth]

You only have three *rows* defined in the lookup range. The HLOOKUP
function will look for the search value in the top row of the range .... row
16 .... between the columns defined in the range ... A to H ... and return
the value from the specified row ... 2 ... which in this case would be row
17.

If your values are listed in a column, then maybe you should be using
VLOOKUP.

Regards

Trevor