Hi
I am working on stock workbook
each item has a reference
the first sheet is the main sheet with all the reference numbers and
their name
the other sheets are for the stock in stock out
the data in the Main sheet are the following
C6:C194= Account number
D6:D194= Account Name
in the stock in stock out sheets
A7=account name ???????? =LOOKUP(B8,Main!C7:D195)
B7= Account number

I was using this formula but im doing something wrong cause it is
giving me another name

Tia

Try in B7: =INDEX(Main!$C$6:$C$194,MATCH(A7,Main!$D$6:$D$194, 0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000, Files:358, Subscribers:55
xdemechanik
---
"Tia" wrote in message
...
I am working on stock workbook
each item has a reference
the first sheet is the main sheet with all the reference numbers and
their name
the other sheets are for the stock in stock out
the data in the Main sheet are the following
C6:C194= Account number
D6:D194= Account Name
in the stock in stock out sheets
A7=account name ???????? =LOOKUP(B8,Main!C7:D195)
B7= Account number

I was using this formula but im doing something wrong cause it is
giving me another name

Tia

This is a great resource for things pertaining to Index/Match:
http://www.contextures.com/xlFunctions03.html


Regards,
Ryan---

--
RyGuy


"Max" wrote:

Try in B7: =INDEX(Main!$C$6:$C$194,MATCH(A7,Main!$D$6:$D$194, 0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000, Files:358, Subscribers:55
xdemechanik
---
"Tia" wrote in message
...
I am working on stock workbook
each item has a reference
the first sheet is the main sheet with all the reference numbers and
their name
the other sheets are for the stock in stock out
the data in the Main sheet are the following
C6:C194= Account number
D6:D194= Account Name
in the stock in stock out sheets
A7=account name ???????? =LOOKUP(B8,Main!C7:D195)
B7= Account number

I was using this formula but im doing something wrong cause it is
giving me another name

Tia