Hi There,
I am using a Vlookup function to ascertain the most succesfull type of bowl. For example below is how my table is set up.
Right 2
Left 2
Drive 0
Right Weight 1
Left Weight 0
Most Succesful Bowl 1.
2.
3.
I have done a Vlookup to find the maximum value and state where the maximum value was produced using a right, left, drive bowl etc, however when i have two matching criteria i.e. both left and right have a value of 2, how can i create a formula to place Right in most succesful bowl 1 and left in most succeful bowl 2?
I have tried using another worksheet to show my results in order using =LARGE(B1:B3,1), =LARGE(B1:B3,2) and so on, and then performing Vlookups on these cells,but the Vlookup works on the cell Value and as 'Right' is the first cell containg 2, the results come out as most succeful bowl 1:Right, Most succesful bowl 2:Right
Please Help
Cara_01
I am using a Vlookup function to ascertain the most succesfull type of bowl. For example below is how my table is set up.
Right 2
Left 2
Drive 0
Right Weight 1
Left Weight 0
Most Succesful Bowl 1.
2.
3.
I have done a Vlookup to find the maximum value and state where the maximum value was produced using a right, left, drive bowl etc, however when i have two matching criteria i.e. both left and right have a value of 2, how can i create a formula to place Right in most succesful bowl 1 and left in most succeful bowl 2?
I have tried using another worksheet to show my results in order using =LARGE(B1:B3,1), =LARGE(B1:B3,2) and so on, and then performing Vlookups on these cells,but the Vlookup works on the cell Value and as 'Right' is the first cell containg 2, the results come out as most succeful bowl 1:Right, Most succesful bowl 2:Right
Please Help
Cara_01