Hi,
I have a question on double vlookup. I have try to search this forum for any related info but dun quite find what I am looking for. My problem is like this
0|__A_____B____C_______D
1|_____<50___51-60____>61
2|_AA__100___101______102
3|_BB__103___104______105
4|_CC__106___107______108
so what I need to do is I need to return the value for AA with 53, that is it will return the value of 101. Another instance is when I need CC with 65, it will return 108. How do I do a double lookup so that I can look at the column and pick up whether AA,BB or CC and then look at row 1 to see whether it is below 50, between 51 and 60 or more than 61?
Please Help...Thanks in advance
I have a question on double vlookup. I have try to search this forum for any related info but dun quite find what I am looking for. My problem is like this
0|__A_____B____C_______D
1|_____<50___51-60____>61
2|_AA__100___101______102
3|_BB__103___104______105
4|_CC__106___107______108
so what I need to do is I need to return the value for AA with 53, that is it will return the value of 101. Another instance is when I need CC with 65, it will return 108. How do I do a double lookup so that I can look at the column and pick up whether AA,BB or CC and then look at row 1 to see whether it is below 50, between 51 and 60 or more than 61?
Please Help...Thanks in advance