retrieving

Hi Folks, I am using a simple VLOOKUP for retrieving a value in another sheet in the same workbook but just keep getting #REF ! error. Think that I overlooked something. The formula is =VLOOKUP(F3,'Precios '!$A$3:$A$83,2,FALSE) And what I am trying to do with this is to search for value...

Hi, I am trying to find a way of listing data from Column DW if column ED is Greater than 0 and column EK is "ABC" I would ideally need the data to be under each other rather than on separate rows Hope this makes sense Many thanks

Good morning, I am trying to retrieve the non zero cell from a range of cells to a new column (please see table below). I tried Index and Match with little result. Any recommendation would be appreciated! Thanks, <tbody> A B C D 0 4 0 -> 4 5 0 0 -> 5 AA 0 0 -> AA 0 0 8 -> 8 </tbody>

<tbody> Hi, All the expert people out there. I am stuck in a problem and have tried lots of option but no success.I have two sheets in one worksheet and I am comparing 2 columns to retrieve the value from one into another. screenshot attached The problem is that the sheet I am retrieving the...