Doing a VLOOKUP IF a column doesn't contains a specific value

[Ramenator]

Hey guys, wondering if you could help me out with this.

I have a VLOOKUP formula right now that looks up a value X3444 in a table and returns the 10th column. The problem is that there are multiple entries of X3444 in the table. Now, there is another column, let's say column 5, in this table that either has an X or does not. If the X is present, then I would like to not do the VLOOKUP for X3444 in that row.

Hope this is clear enough.

Thanks in advance!

 

[Jonmo1]

Try

=IF(E3444="X","",VLOOKUP(X3444,table,10,FALSE))

 

[Ramenator]

I should have probably included some more relevant info. Thanks for the feedback so far, Jonmo1.

So this is the formula used in Workbook 1 and it is referencing rb_hsa_data.xlsx which would be Workbook 2.

=VLOOKUP(Zones[[#This Row],[Eng]],[rb_hsa_data.xlsx]report_result!C2:C51,50,0)

So when I do the VLOOKUP in Workbook 2, I want it to only return the data IF the same row it's looking up has an X in another column.

So for example below:

I want my VLOOKUP in Workbook 1 to reference this data in Workbook 2 and I want it to return data in columns 10 and 11 only if there is no X in column 3.

Cheers and thanks again.