Sir,
1 lookup range are covered in single column(A2:A513) the sheet Name is Req Format.
2 lookup range are covered double column (A2:A183) and (E2:E183) the sheet Name is Data
3 Am apply lookup formulas two times from to various range that the cell is column F&G the Sheet Name is Req Format.
Formula is
Column F:
{VLOOKUP($A3&B3&C3,CHOOSE({1,2,3},Data!$A$2:$A$183&Data!$B$2:$B$183&Data!$C$2:$C$183,Data!$D$2:$D$183),2,0)}
Column G:
{VLOOKUP($A3&B3&C3,CHOOSE({1,2,3},Data!$E$2:$E$183&Data!$B$2:$B$183&Data!$C$2:$C$183,Data!$D$2:$D$183),2,0)}
4 after apply the formulas both of two column value return is wrongly(first cells value picking)
5 How do combined two ranges
My querry is
When vlookup ranges is multiple: How do vlookup Value finding Occurrence against corresponding to the reference.
file attached.
please help me.
Bookmarks