Firstly, can I say that I am not sure if VLookup is the correct way to go about this problem. I am a beginner in vba so please bear with me.
See attcahed file which is example of what I aim (with assistance ) to achieve.
Depending on 2 variables, Size and Area, I want to lookup and report value to another box on the same page.
Example: Size = 6 (looks down col A to find 6 @ Row 2) then Area = Malaysia (which then looks across Row 2 to find Malasia in Col F) and return the value where these two meet (552.00)........hope this makes sense!
Thanks in advance
Steve
Bookmarks