| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Formula
I have Sheet1 with 3 columns; (Column A) Lot Number, (Column B) Lot Address,
(Column C) Resident In Sheet2 I need something like if cell Sheet2!A2 contain value from Sheet1 ColumnA (any cell in column A) then Sheet2!A3 will contain the value from Sheet1 ColumnB (same row) To clarify if i enter a lot number I want in the cell next to it the Lot address Both calues are in Sheet1 same row I try to do =IF(C2=1,Sheet2!B1,IF(C2=2,Sheet2!B2)) and it works fine but i need to stop to 62 because of the nesting limit in Excel I need to get to 82 I hope this is clear |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Formula
Check out help on VLOOKUP()
In Sheet2 cell A2 enter a lot number. In cell B2 enter the below formula =VLOOKUP(A1,Sheet1!A:C,2,0) and in cell C2 enter =VLOOKUP(A1,Sheet1!A:C,3,0) -- Jacob "bobmuse" wrote: I have Sheet1 with 3 columns; (Column A) Lot Number, (Column B) Lot Address, (Column C) Resident In Sheet2 I need something like if cell Sheet2!A2 contain value from Sheet1 ColumnA (any cell in column A) then Sheet2!A3 will contain the value from Sheet1 ColumnB (same row) To clarify if i enter a lot number I want in the cell next to it the Lot address Both calues are in Sheet1 same row I try to do =IF(C2=1,Sheet2!B1,IF(C2=2,Sheet2!B2)) and it works fine but i need to stop to 62 because of the nesting limit in Excel I need to get to 82 I hope this is clear |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Formula
thank you
i could not make the Vlookup work like you did "Jacob Skaria" wrote: Check out help on VLOOKUP() In Sheet2 cell A2 enter a lot number. In cell B2 enter the below formula =VLOOKUP(A1,Sheet1!A:C,2,0) and in cell C2 enter =VLOOKUP(A1,Sheet1!A:C,3,0) -- Jacob "bobmuse" wrote: I have Sheet1 with 3 columns; (Column A) Lot Number, (Column B) Lot Address, (Column C) Resident In Sheet2 I need something like if cell Sheet2!A2 contain value from Sheet1 ColumnA (any cell in column A) then Sheet2!A3 will contain the value from Sheet1 ColumnB (same row) To clarify if i enter a lot number I want in the cell next to it the Lot address Both calues are in Sheet1 same row I try to do =IF(C2=1,Sheet2!B1,IF(C2=2,Sheet2!B2)) and it works fine but i need to stop to 62 because of the nesting limit in Excel I need to get to 82 I hope this is clear |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
