I have in the spreadsheet:

the columns contain descriptions of events and each event can have an error
code attached.
Log_off Fill in form Section blank
row 1 2 4 5

the errorcode table on another sheet

Log_off 1 logged off correctly no action
Log_off 2 logged off incorectly teach how to log off

Fill in form 1 Filled in correctly no action
Fill in form 2 filled form incorectly teach how to fill in
form

How do I do the vlookup in this case as if I just used the numerical column
it wouldnt know which 1 of 1 or 2 of 2 to return.

Logically it wants to lookup the first column ie Vlookup description of
error and then vlookup the number within that desription.


Hope that makes sense.

Regards
Peter