Hi there,

I have a table with machine specifications.
There are machines with same name, but different length and therefore
different prices.

I'm looking for a vlookup formula (or any other solution) which can
check for both: name and length and give me back the price.
(I don't like the suggestion to have a cell with name and length as
one entry, as the table is imported from a different source)

A B C
1 name length price
2 ABD 2000 1850
3 ABD 2500 2050
4 ABD 3000 2250
5 EFG 2000 3285
6 EFG 2500 3568
7 EFG 3000 3859


which price has the machine ABD with a length of 2500mm?

Any help is very much appreciated.

Best regards,
Norbert Jaeger