I want to ask about how to retrieve the data from another sheet in one excel but the key data is contained in another sheet.
For example i have 1 excel contains 2 sheet.
The Column “NO” in the sheet 1 is the key data
This is sheet 2
As displayed the column “NO” is also in sheet 2 but with different number
The same is 100001 until 100003.
So my logic is if the column “NO” between the 2 sheet is same then the data that i want is column “price” in sheet2
is it need to build the data table between the 2 sheet and then using if function?
I hope you can understand my question. Thanks a lot