How to get info from adjacent cells

M

MIK

Hi,

I have vendors information on sheet #1. Each vendor has its numerical ID.
Info such as address , city, State, Tel, Fax are in the same row in separate
cells. On sheet # 2, I want to create a form that will require all of the
above info in differnt cells. Is there a way that on my form, if i enter the
ID#, the othe cells will get address, tel, fax etc. from sheet #1.
 
B

Billy Liddel

Hi

VLOOKUP(ID,TableName or range,Offset column,O) Zero is the type and will
return #N/A! value if ID is not in in the table.

Look in help for more details.

Peter
 
S

Shane Devenshire

Hi,

You want to use the VLOOKUP functions such as

=VLOOKUP(A1,Sheet2!A$1:F$100,2,FALSE)

In this example you are looking up the ID in cell A1 in column A of Sheet2
and your are returning the entry in column 2 of that table from the row with
a matching ID.

You can simplify this to

=VLOOKUP(A1,Sheet2!A$1:F$100,2,0)
but not
=VLOOKUP(A1,Sheet2!A$1:F$100,2,O)

(the last argument is zero not the letter "O".

You can simplify this further to

=VLOOKUP(A1,Sheet2!A$1:F$100,2)
 

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

Top