Use MATCH to find the row and then -1 and INDEX the column match row,1

--
Don Guillett
SalesAid Software

"steve alcock" wrote in message
...
Hi team,

need big help here :

I want to be able to lookup from one worksheet with a value of 7191 on
sheet2
b6:db52, match the value ( 7191 ) then return me the cell information
directly above the matched cell, anyone any ideas please

thanks

steve