How to V look up 2 Sheets

[punnipah]

How to V look up Sheet VBA please Help.

VBA Code

I have Data 2 Sheets "Sale Volume" and " DT
I would like to V look up Sheet 1 "Sale Volume" Columns B (Order No.) ,Range B5 (Vlook up) with Sheet 2 "DT" Columns B (SALE_ORDER_OTH_NO )
Ex.

=VLOOKUP($B5,DT!B:F,1,0)



Sheet (Sale Volume)

Order Date	Order No.	Order Status	Total	B5 Vlook up
4/10/2021	448476047122165	Delivered	199.00
4/10/2021	448488845336549	Delivery Failed	50.00
4/10/2021	448523486837059	Delivered	2,490.00
4/10/2021	448544425253986	Delivered	2,490.00
Sheet (DT) RECPT/INV DATE SALE_ORDER_OTH_NO RECPT/INV NO Sum of GRAND TOTAL 04/10/2021 448476047122165 1120211000000647 199.00 04/10/2021 4448488845336549 1120211000000634 50.00 04/10/2021 448523486837059 1120211000000631 2,490.00 04/10/2021 448544425253986 1120211000000651 2,490.00 Thank You,

 

[My Aswer Is This]

I'm not very good using such formulas.
If your looking for a Vba solution please explain in detail what your objective is:

 

[punnipah]

I'm not very good using such formulas.
If your looking for a Vba solution please explain in detail what your objective is:

I would like to V look up BTW Sheet 1 and Sheet 2 Ex.=VLOOKUP($B5,DT!B:F,1,0)
How to write Code VBA ?




Thank you

 

[My Aswer Is This]

I would like to V look up BTW Sheet 1 and Sheet 2 Ex.=VLOOKUP($B5,DT!B:F,1,0)
How to write Code VBA ?




Thank you

But see I never use VLookUp

Can you please tell me what your objective is:
Without using VLookup

 

[punnipah]

But see I never use VLookUp

Can you please tell me what your objective is:
Without using VLookup

I want to find the same values and return the result of the Range "B"

 

[My Aswer Is This]

But see I never use VLookUp

Can you please tell me what your objective is:
Without using VLookup

Most times when using Vba you do not need to use formulas like this:
We use Vba code.