Help with Formula

B

bobmuse

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
 
J

Jacob Skaria

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)
 

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

Need Help with a VBA subroutine 0
Need help to fix vlookup function in macro 1
Macro to copy top 3 value in column 1
Sheet to sheet code Type Mismatch 6
loop to copy paste 5
modified pivot table using a macro 2
HELP: Match values from different sheets and populate a column 3
Array with many cells from a row but not in order or together 11

Top