| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a way to do 4 instructions with one macro | Excel Discussion (Misc queries) | |||
| need help making a formula | Excel Worksheet Functions | |||
| Making too much of a formula | Excel Worksheet Functions | |||
| Do you have instructions for making check boxes? | Excel Worksheet Functions | |||
| Do you have instructions for making check boxes? | Excel Worksheet Functions | |||
Linear Mode
