vlookup instructions,, or help making a formula

  • Thread starter Thread starter excel challanged
  • Start date Start date
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
 
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
 
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
Click to expand...
 
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

?????
 
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.
 
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
 
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
 
Back
Top