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...
excelnewbie12345 Today, 05:58 PMI had to manipulate the source data to force a couple of items for today's date....
Bob Phillips Today, 05:13 PM[QUOTE=rj1600;45495]still isn't producing anything for me.
it runs now, but nothing happens[/code]
You need to have some data with...
And a Power Query solution at cell K1. Right-click and choose Refresh to update....
p45cal Today, 04:25 PM
Formula for index match if two different lengths
Show the actual Index/Match formula that you are using to populate Column H in worksheet 1....
Roger Haney Today, 06:59 PM