match or vlookup for filling data

andrej · Mar 15th 2017

Hi,

I would like to enter data from sheet1 to appropriate fields in sheet2 (as shown in example). I thought I could do this with match and index formula, but am having problems, due to many criteria and big search field in sheet 1. Any ideas for help?
forum.ozgrid.com/index.php?attachment/71774/

Thanks,

**NBVC** · Mar 15th 2017

Re: match or vlookup for filling data

After you make sure that the headers in both sheets are spelled correctly and match exactly (including checking for trailing spaces)... try, in B5:

[COLOR="#0000FF"]=INDEX(INDEX(Sheet1!$B$2:$B$55,MATCH(B$3,Sheet1!$A$2:$A$55,0),0):Sheet1!$C$55,MATCH($A5,INDEX(Sheet1!$A$2:$A$55,MATCH(B$3,Sheet1!$A$2:$A$55,0),0):Sheet1!$A$55,0),MATCH(B$4,Sheet1!$B$6:$C$6,0))[/COLOR]

copied to next column and down both column

This will look for the required "Partner" and search from that point down.

match or vlookup for filling data

Participate now!

Share