View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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