Value from table/for invoice use

[Dirk Taljaard]

Hi.

I have the following problem that I struggle to solve myself. Please help...

BMS - Data.jpg

I would like to type my criteria and get the returns as indicated.

For the return at L6, I suppose the function must first look at column B, then C, then D, then E?

Thanks

Dirk

[FDibbins]

Hi Dirk, welkom aan die forum

Waar omtrent in SA? ex-pat from PE and Klerksdorp here, now living in USA.

For L6, try this...
=INDEX(F$6:F$180,MATCH($K6,INDEX($B$6:$B$180&$C$6:$C$180&$D$6:$D$180&$E$6:$E$180,0),0))
For O6...
=INDEX(I$6:I$180,MATCH($M6&N$6,INDEX($G$6:$G$180&$H$6:$H$180,0),0))

[Dirk Taljaard]

Hi Ford

That really helped to solve it. Thanks!

Nog altyd in Centurion Pta. Ek was al in PE en Klerksdork maar ken nie die plekke so goed nie.
Ek dink ek gaan nog vrae he later. Wil binnekort 'n goeie excel kurses doen.

Dankie vir die hulp!

Groete Dirk

[FDibbins]

Dirk, happy to help

Been to P-town a few times, but would get lost real quick lol.

Look forward to helping with more questions