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