Organizing data into easier format

[ZealotAssasin]

I've attached the file, the "Data" and "Data2" tabs are two examples of what I get and the "Format" tab is where I want the data formatted into. The data doesn't alway start on the same row, but I figure I can look for the date in Column C for where I can start the macro.

These are pant sizes (e.g. 30x30, 40x34), with the numbers lining across the columns as the first number and the numbers lining up in each row as the 2nd number with an "x" in between.

Thanks

[ZealotAssasin]

Anyone have any ideas?

[jaslake]

Hi ZealotAssasin

What's your expected output look like based on your sample file?

[JBeaucaire]

Formulaically, put this formula in B3 and copy down:

=INDEX(Data!$F$19:$N$23, MATCH(RIGHT(A3,2)+0, Data!$E$19:$E$23, 0), MATCH(LEFT(A3,2)+0, Data!$F$18:$N$18, 0))