Thank-you for looking at my question!

I suppose I am trying to perform multiple (embedded) VLOOKUP's although
there may be another way I can achieve the same result.

I have a list of server names (column A down) and a row of patch names (Row
2 along) I have another sheet in my workbook containing patch scan results
(hostname_patchname) which I have defined as name 'database' and am looking
up if each server has the patch or not.
=vlookup($A2&"_"&B$1,database,2,false) This is working a treat, however I
need to do this based on whether a patch is applicable to each particular
server. I have another data area with all the server names and what operating
system they are running and want to only show a result per patch if said
patch is relevant to that server. Hope this makes sense to someone without a
view of the sheet :-)

Many thanks for any help anyone can provide.
Scott