Vlookup and If conditions together along with match formulas
Please help me with the below conditions. I need to fulfill 2 different conditions from two cells and then give me a correspoding value.
Workbook 1(Aset mov form) has the data. Workbook 2 (Floor map)should be updated based on workbook.
In workbook 2, i need the following:
Vlookup for deskno in workbook 1, if it is present, then the service line, cell next to deskno should match with the service line in workbook 1. If these both conditions match, then it should give the name corresponding to that match. I tried the below formula.
=IF(AND(H18=VLOOKUP(H18,'[Asset_movm_form.xlsx]Asset movement details'!$H:$H,1,0),H16=VLOOKUP(H16,'[Asset_movm_form.xlsx]Asset movement details'!$I:$I,1,0)),VLOOKUP(H18,'[Asset_movm_form.xlsx]Asset movement details'!$H:$M,6,0)). Though this fulfills my purpose, i am looking for cell specific values rather than the entire column for service line column.
Please suggest friends..
|