vlookup instructions,, or help making a formula
 

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

vlookup instructions,, or help making a formula
 

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" wrote:

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

vlookup instructions,, or help making a formula
 

"Sheeloo" wrote:

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" wrote:

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

vlookup instructions,, or help making a formula
 

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" wrote:

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" wrote:

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

vlookup instructions,, or help making a formula
 

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" wrote:

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" wrote:

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" wrote:

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

vlookup instructions,, or help making a formula
 

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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

vlookup instructions,, or help making a formula
 

Since Sheet2 has the data like
1 0015 Applesauce $.04
2 0021 Bagel $.11
3 0045 Bean Garbanzo $.15

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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

vlookup instructions,, or help making a formula
 

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


"Sheeloo" wrote:

Since Sheet2 has the data like
1 0015 Applesauce $.04
2 0021 Bagel $.11
3 0045 Bean Garbanzo $.15

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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