Excel formula - Looking up based on Criteria

[maslam15]

Hello Everyone,
My Table is called "Master" where all of my data is located. In a seperate tab I want to copy the IPAddress which is on Master Tab column number 9 (Column I).
Here are my conditions to be able to copy the correct data. I want to be able to look up by HOSTNAMESHORT which can be something like abcwccldvapp01 or abcwccldvapp02 and so on located on column number 18 (R) and each of these can share same QID such as 123 located column number 26 (Z). What formula can I use to copy the IPAddress.
Thank you,

 

[Fluff]

Can you post some sample data for both sheets using the XL2BB add-in.

 

[maslam15]

IPAddress	HOSTNAMESHORT	QID
00.2431.1537	absxzccwprdb01	1000​
12.2431.1536	absxzccwprdb02	1000​
10.231.156.62	kuszbccpoosql03	1121

 

[Fluff]

Can you please use the XL2BB add-in. That way I can see what rows & columns you have, plus I can then just copy/paste the data straight into Excel.
I also need to see how the data is laid out on the other sheet.