try something like
if your applicability database is set with Servers in the first column and
the Patches in the first row with a applicable or not applicable indicator in
the intersection cells

=if(Vlookup($A$28,Applicability database,match($B$1,Patch row
description),false),vlookup($A2&"_"&B$1,database,2 ,false),"")

"Milky_UK" wrote:

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