How To Use VLOOKUP Between Two Worksheets - VLOOKUP In Excel

Here, I explain using VLOOKUP between two worksheets to get related data automatically in excel. VLOOKUP is very useful excel formula and it is usually being used between two different excel worksheets and this is how to do it in details. This excel formula is widely used by quantity surveyors in the construction industry while doing quantity takeoff. Very recommended video for everyone. Examples of VLOOKUP can be when quantifying walls and steel reinforcement.

You can enroll to our complete Quantity Surveying and Cost Estimation online courses from these below links:

**Link to Construction Cost Estimation Course "The Ultimate Guide":

**Procurement Course:

If you would like to see takeoff content similar to our course for free , please visit our YouTube channel:

If you would like to join our Facebook page where we discuss everything related to quantity surveying and cost estimation:

[nabeelattari]

its great video adel . please make more videos on excel formulas which is most helpful for a QS or Cost Engineer

[danielleneilson]

You're videos are very practical, helpful. Thank you!

[solidjasonlaz]

Easily understandable presentation. Cheers.
Keep making more videos basha

[eugeneb]

Hi I plan to buy excel for building services engineering. Please can you advise if available and how much it costs ?

[mohamedzabry]

Great explanation Sir, keep it up
I expect from you a variation calculation video.

[duraidalghabra]

Thanks Dear Ahmad, but the music is little nosy

[wendypilkington]

Followed the instructions exactly didn't work. Do I need to use $ ?