I have requirement as below
There is excel sheet 1 with column A with some text say xxx, yyy , xyz and coresponding numeric values in column B, C, D , E for each row in column A.
Now I have to vlookup the Text of column A from sheet 1 and bring all the column numeric values in Sheet 2 . ( sheet 2 will have the text in different orders in Column A , hence copy paste will not workout) .
Sheet example as below .
Colm A B C D E
Part no Wk1 Wk 2 W 3 Wk 4
XXX 1 0 4 5
XYZ 3 2 0 2
YYY 2 4 0 3
ZZZ 5 5 3 1
I have tried with below formula , =VLOOKUP($A2,[Book1]Sheet1!$A$2:$E$5,2,0)
whereas i need to change the shell formula in each column row which is taking lot time , also leading to errors
Formula as below for each shell
i.e the column is changed from 2 to 5 in each column , once i did this forumla change in Row 1, then i can copy whole row formulas and paste it in Row 2 ,3 ,4 .
But still its a hectic work to change the formula in each column of row 1 , Is there any formula to simplify this action , instead of doing it in one bye one . Pls help