Forum Discussion
Complex Vlookup
Hello, Interest issue it will be great to hear solution for my problem . 2 Tables : 1. One of them with rows, and one of them with columns 2. Need to compare the # and Type columns between the ta...
Thx Quadruple
Its still not working
I will try to define my request again :
1. Compare the 2 tables
2. Table A : Type field is by row (and not by column- like table b).
I need to receive a result at the price field by rows , for example :
01.07.00.001 - 1005 : result should be , 5
01.07.00.001-1006 : result should be ,10
etc' - hope it's more clear now
Its still not working
I will try to define my request again :
1. Compare the 2 tables
2. Table A : Type field is by row (and not by column- like table b).
I need to receive a result at the price field by rows , for example :
01.07.00.001 - 1005 : result should be , 5
01.07.00.001-1006 : result should be ,10
etc' - hope it's more clear now
OliverScheurich's formula is correct, but you have to adjust the ranges and cell references to match your actual layout, of course.
See the attached sample workbook.