Problem with HLookup

I can do vlookups!

and i thought hlookups would be as easy …but they are not (for me anyway)

I have an array and i need to look over some columns and see if a string
(Which comes from a drop-down list on sheet2) is there and return another value from the array


any ideas ?


i cant work out how to attach a sample spreadsheet …sorry 

By: Eddie

Leave a Reply

Your email address will not be published. Required fields are marked *