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.
精彩评论