vlookup instructions,, or help making a formula

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
 
S

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
 
E

excel challanged

Sheeloo said:
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
 
E

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

?????
 
S

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.
 
E

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top