Hi,

I need to do the following lookup -

Table array

Item Price 1 Price 2 Price 3 Price 4
Vent1 £10.00 £15.00 £20.00 £25.00
Vent2 £12.00 £13.00 £15.00 £16.00
Vent3 £15.00 £20.00 £21.00 £23.00

In main spreadsheet

ColumnA Column B Column E
Vent2 Price 1
Vent1 Price 4
Vent3 Price 2
Vent3 Price 3
Vent2 Price 2

I want it to look at the Price and the item to put the cost in Column E

Thanks

Natalie