Database as source

  • Thread starter Thread starter Rui
  • Start date Start date
R

Rui

Hello guys!

I'm trying to desgin a Invoice in excel, but i've stoped by a problem
that i cannot resolve.

What i am trying to do, is to type a number in sheet 1 and in a
automated mode, get some values in sheet 2, that corresponding to the
typed number.

Sheet 1, is my invoice design
Sheet 2 is my costumer list

How must i have my costumers list? Each costumer information in rows,
or columns? What is the function that i need?

Thanks!

Rui
 
Look in the Excel help for the VLookup function Rui

=VLOOKUP(A1,Sheet2!A2:B100,2)

It will look in A2:A100 of Sheet2 for the number and display the value
in the B column
 
I have a worksheet set out like a form to show the different fields of
single row in my separate database sheet, but in a column.

1. I have single cell C21 to enter a project number.

2. This formula in cell C23 looks up the item in column A of m
database sheet and shows the row number if found.
=MATCH(C21,database!A:A,0)

3. In column A (hidden) against the field items I have typed the colum
number of the item in the database.

4. This formula copied down column B from B4 shows the field names fro
row 1 of my database.
=INDIRECT("'database'!R1c" &$A4,FALSE)

5. This formula copied down column C from C4 uses the row number in C2
and column number in column A to look up the item in the database t
show the detail in the cell C4 :
=INDIRECT("'database'!R" &$C$23 &"c" &$A4,FALSE)
 
Back
Top