开发者

Search for a value in a range, then copy values in first empty row of another sheet

I tried various functions but can't get it to work.

I need to search for the value Diesel and copy next开发者_高级运维 three cells to last line of another sheet. I need to copy only the values, as these are formula based cells.

My Excel sheet goes something like this.. (the sheet extends horizontally with similar fields)

 Fuel   Machine Meter reading   Quantity     Fuel   Machine Meter reading   Quantity
 Diesel CAT 03        22              5      Diesel  CAT 03      54            54 
 Petrol CAT 04        22              45     HY oil  CAT 03      54            48 
 -       -             -     -               -       -               -       -   
 -       -             -     -               -       -               -       -   


Copied from a comment by IDevlop:

You CAN do this without VBA by using 3 vlookup functions. See vlookup help for details, and don't forget to set the last parameter (exact_match) to FALSE.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜