V
Vacuum Sealed
Hi All
Can anyone have a look at this and put it into the right syntax please....
'=IF(A2="","",IF(A2="Company",VLOOKUP(B2,Lookups!$A$2:$D$98,2,IF(A2="Subbie",VLOOKUP(B2,Lookups!$A$101:$D$198,2,IF(A2="Agency",VLOOKUP(B2,Lookups!$A$201:$D$298,2,FALSE))))))).
I'm not sure if I should be using Match | Index or what.
Column A is a Data Validated lookup with 3 choices:
Company, Subbie, Agency
Column B is the filtered result of Column A
So If I select Company - Column A and John Doe - Column B, I would like the
above to return his details in Column C, which is where the above is
located.
Each Group has its own lookup range.
It would probably be easier if I named the ranges and referred to them
directly, but as yet, I haven't dealt with that before so I'm somewhat
hesitant...
TIA
Mick.
Can anyone have a look at this and put it into the right syntax please....
'=IF(A2="","",IF(A2="Company",VLOOKUP(B2,Lookups!$A$2:$D$98,2,IF(A2="Subbie",VLOOKUP(B2,Lookups!$A$101:$D$198,2,IF(A2="Agency",VLOOKUP(B2,Lookups!$A$201:$D$298,2,FALSE))))))).
I'm not sure if I should be using Match | Index or what.
Column A is a Data Validated lookup with 3 choices:
Company, Subbie, Agency
Column B is the filtered result of Column A
So If I select Company - Column A and John Doe - Column B, I would like the
above to return his details in Column C, which is where the above is
located.
Each Group has its own lookup range.
It would probably be easier if I named the ranges and referred to them
directly, but as yet, I haven't dealt with that before so I'm somewhat
hesitant...
TIA
Mick.