Reply With Quote
Show the actual Index/Match formula that you are using to populate Column H in worksheet 1.
I'm using index match to match an id from one worksheet1 to worksheet 2 and populate the field worksheet 1 (ROW H). However, the index match isn't working for the entire array--I'm guessing it's because of the different lengths?? Is there something else I can do?
Show the actual Index/Match formula that you are using to populate Column H in worksheet 1.
Last edited by Roger Haney; 2021-01-24 at 07:01 PM. Reason: Spelling error
This works for me
=INDEX(Worksheet2!H:H,MATCH(worksheet1!D2,Worksheet2!D:D,0))
Bookmarks