Lookup, Match, structed table

Hi All

Please see spreadsheet

Im trying to use a lookup formula to return txt in another column but cant get it to work

=VLOOKUP([@DeliveryPoint],'Lookup table'!B2:E76,2,TRUE)

More details on the attached spreadsheet

Thanks in advance

Try either,
=VLOOKUP([@DelPointName],Table2[[DelPointName]:[Reason]],2,0)
=INDEX(Table2[Reason],MATCH([@DelPointName],Table2[DelPointName],0))

Hi Josephteh

Thanks for the reply

I'm afraid I cant get the either of the formula's you have provided to work.

Can you give me a bit more detail please

Please see attached file.

Just change [@DelPointName] to [@DeliveryPoint]

Sorry about this but i must be missing something

I have changed has you have suggested but its not working

I do thank you for you time and patience

Please attach your workbook.

Work book attached

You only change column Q formula. What exactly is wrong?

Trying to get the formula in Q to lookup and match D (DeliveryPoint) with (Lookup table) Coloulm B and then return D (Reason)

Then the same in R o lookup and match D (DeliveryPoint) with (Lookup table) Coloum B and then return E (Action)

Which row is wrong?

None of the DeliveryPoint in Planned orders is listed in the Lookup table.

Currently lookup and match against Delivery Name and not delivery point

Del point is unique where the del name can repeat

I don't understand you. I give up!

When the table updates then there will be some matches

See attached

Data now got matches against del point

Just copy one of the DeliveryPoint in Planned orders to the Lookup table and you can see a match.

If you want to flag errors, like showing nothing if no matches, then change the formula to:

PHP Code: 

=IFERROR(INDEX(Table2[Reason],MATCH([@DeliveryPoint],Table2[DeliveryPoint],0)),"") 


And, in Action,

PHP Code: 

=IFERROR(INDEX(Table2[Action],MATCH([@DeliveryPoint],Table2[DeliveryPoint],0)),"") 


So, now you want to match the date as well?

Add in "--" in formula:

PHP Code: 

=IFERROR(INDEX(Table2[Reason],MATCH(--[@DeliveryPoint],Table2[DeliveryPoint],0)),"") 


PHP Code: 

=IFERROR(INDEX(Table2[Action],MATCH(--[@DeliveryPoint],Table2[DeliveryPoint],0)),"") 


Thanks for all your help