Hello,
I thank anyone who will be able to help me in advance!
i'm trying to create a macro that will vlookup a different excel file for data while searching for two values
it has to look for two values because for example in the image i'd like to search for DV20, this is how the other excel file looks like (it's an automated mail from a bot):
it would have to search for the result in the range table of 20's for DV and will extract just the outcome of 25 under available, the same with a table for 40's.
i'm very much a novice and all the coding i've tried failed..
I thank anyone who will be able to help me in advance!
i'm trying to create a macro that will vlookup a different excel file for data while searching for two values
it has to look for two values because for example in the image i'd like to search for DV20, this is how the other excel file looks like (it's an automated mail from a bot):
it would have to search for the result in the range table of 20's for DV and will extract just the outcome of 25 under available, the same with a table for 40's.
i'm very much a novice and all the coding i've tried failed..