vlookup instructions,, or help making a formula

[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

 

[Sheeloo]

in B1 of Sheet2
=VLOOKUP(A1, Sheet1!A:C, 2, False)

....you can also use =VLOOKUP(A1, Sheet1!A:B, 2, False)

and in C1 of Sheet2
=VLOOKUP(A1, Sheet1!A:C, 3, False)

VLLOKUP takes the value in A1, goes to the first Col of lookup range
(Sheet1!A:C), finds a match, moves over to the Col no in the range (2 or 3 in
your case) and returns the value there.

With TRUE lookup values need to be sorted and closest match is returned

 

[excel challanged]

in B1 of Sheet2
=VLOOKUP(A1, Sheet1!A:C, 2, False)

...you can also use =VLOOKUP(A1, Sheet1!A:B, 2, False)

and in C1 of Sheet2
=VLOOKUP(A1, Sheet1!A:C, 3, False)

VLLOKUP takes the value in A1, goes to the first Col of lookup range
(Sheet1!A:C), finds a match, moves over to the Col no in the range (2 or 3 in
your case) and returns the value there.

With TRUE lookup values need to be sorted and closest match is returned

 

[excel challanged]

it comes up #N/A in cell, B1 of Sheet 2, and C1 of Sheet2
I did some thing wrong or i'm just not getting it

?????

 

[Sheeloo]

What is the value in A1?
It should be one of the values in Col A of Sheet1... and format should be
the same...
You get #N/A when the value is not found.

 

[excel challanged]

the value on Sheet 1 ,Cell A4 is the stock # 0015 ( starts in A4)
the value on sheet 2 cell a4 i want to plug in the stock number and have it
auto maticly put into , sheet 2 cell b4,
The formula is correct << using the wizard
Lookup_value (A4) = 15
Table_array (Sheet1!B4:B6) = {"applesauce";"bage
Col_index_num (2) =2
Range_lookup (False) = false

can there be a part of program missing

ty for help

 

[Sheeloo]

Since Sheet2 has the data like
A4 on A1 has to have 0015 (assuming both are text values)
If 00 is shown using formatting then formula should work
To test
enter
15 in A4
go to sheet2
Enter 15 in the cell where you have shown 0015 and format that as number

 

[excel challanged]

Thank You ,,, So So much it worked, the format was not in text