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
Bookmarks