E
excel challanged
sheet 1, has information in three colums, in which i wish to tranpose, to
sheet 2.
sheet 1
A B C
Ex: Fidf# Item Cost
1 0015 Applesauce $.04
2 0021 Bagel $.11
3 0045 Bean Garbanzo $.15
sheet 2
A B C
FIDF ITEM Cost
1 fill in Vlookup??? Vlookup ???
2 fill in vlookup??? vlookup???
3 fill in vlookup??? vlookup???
Fill in is with the FDIF # on sheet 1,,,
Vlookup is from column B sheet1 which i wish to be filled in
automatic when i put the FDIF # in column A on sheet 2.
Vlookup is from column C sheet1 which i wish to be filled in
automatic when i put the FDIF # in column A on sheet 2.
Help please and Thank You
Bob
sheet 2.
sheet 1
A B C
Ex: Fidf# Item Cost
1 0015 Applesauce $.04
2 0021 Bagel $.11
3 0045 Bean Garbanzo $.15
sheet 2
A B C
FIDF ITEM Cost
1 fill in Vlookup??? Vlookup ???
2 fill in vlookup??? vlookup???
3 fill in vlookup??? vlookup???
Fill in is with the FDIF # on sheet 1,,,
Vlookup is from column B sheet1 which i wish to be filled in
automatic when i put the FDIF # in column A on sheet 2.
Vlookup is from column C sheet1 which i wish to be filled in
automatic when i put the FDIF # in column A on sheet 2.
Help please and Thank You
Bob