lookup for a specific string-help please

Try...

=VLOOKUP("Total Excavation",DETAILS!B4:H800,7,0)

or

=VLOOKUP("Total Excavation",DETAILS!B:H,7,0)

Hope this helps!

Hi Domenic ,

Thanks a lot, the second one really works. It really saved my time and tiresome work too.

Expect your valued guidance in future too.

wishin you to the best of the bests

regards
Vinu