Lookup Q

I have a list of Raw Material items in Column A with their costs associated
with them in Column B. I want to design a recipe module whereby I select Raw
Materials that go in to Finished products and their associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted alphabetically?

Thanks

Yes.

-----Original Message-----
I have a list of Raw Material items in Column A with
their costs associated
with them in Column B. I want to design a recipe module
whereby I select Raw
Materials that go in to Finished products and their
associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted
alphabetically?

Thanks



.

Thnaks Manish, the answer I thought I'd hear. Is there any other function I
can use to 'lookup' a value i..e select Raw Material name and return in
another column its cost?


"Manish" wrote in message
...
Yes.

-----Original Message-----
I have a list of Raw Material items in Column A with
their costs associated
with them in Column B. I want to design a recipe module
whereby I select Raw
Materials that go in to Finished products and their
associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted
alphabetically?

Thanks



.

To be *Exact*,
Vlookup, Hlookup, and Index-Match combinations can return exact data without
the list being sorted.

On the other hand the *LOOKUP* function *would* need a sorted list to return
accurate data.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Manish" wrote in message
...
Yes.

-----Original Message-----
I have a list of Raw Material items in Column A with
their costs associated
with them in Column B. I want to design a recipe module
whereby I select Raw
Materials that go in to Finished products and their
associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted
alphabetically?

Thanks



.

I'm using the formula below to find Raw Materials that are selected in
Column D, where the RM costs are in a Range A196:H266 in sheet "Master". The
costs are in Column H; RM are in Column A it returns a #N/A - what am I
doing wrong?



=IF(D9=0,"
",(INDEX(Master!A$196:H$266,MATCH(D9,Products),MAT CH("Cost.",Master!$A$194:$
H$194,))))



"RagDyer" wrote in message
...
To be *Exact*,
Vlookup, Hlookup, and Index-Match combinations can return exact data
without
the list being sorted.

On the other hand the *LOOKUP* function *would* need a sorted list to
return
accurate data.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Manish" wrote in message
...
Yes.

-----Original Message-----
I have a list of Raw Material items in Column A with
their costs associated
with them in Column B. I want to design a recipe module
whereby I select Raw
Materials that go in to Finished products and their
associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted
alphabetically?

Thanks



.

Your description is confusing, with costs in A196:H266 AND costs in column
H?!?
Plus, what are the ranges that your range names represent?

Also, you're using "Cost.", *with* parenthesis and a decimal?!?

Could you post back with a more accurate description of your data list, and
the ranges represented by the range names you're using.


--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"John" wrote in message
...
I'm using the formula below to find Raw Materials that are selected in
Column D, where the RM costs are in a Range A196:H266 in sheet "Master". The
costs are in Column H; RM are in Column A it returns a #N/A - what am I
doing wrong?



=IF(D9=0,"
",(INDEX(Master!A$196:H$266,MATCH(D9,Products),MAT CH("Cost.",Master!$A$194:$
H$194,))))



"RagDyer" wrote in message
...
To be *Exact*,
Vlookup, Hlookup, and Index-Match combinations can return exact data
without
the list being sorted.

On the other hand the *LOOKUP* function *would* need a sorted list to
return
accurate data.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Manish" wrote in message
...
Yes.

-----Original Message-----
I have a list of Raw Material items in Column A with
their costs associated
with them in Column B. I want to design a recipe module
whereby I select Raw
Materials that go in to Finished products and their
associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted
alphabetically?

Thanks



.

It was my attempt at a formula RD thats why its probably confusing!

Within the Range A196:H266 the RM name is located in Column A; costs of
these RM's is located in Column H

D9 is the cell I select a Raw Material, thus the cost I want represented is
the cost of that

'Food' is a range name I've set up but think this incorrect in the formula
as it is just a list of Finished Products which is irrevelant in obtaining
the cost of each Raw Material.

I spotted the DOT in 'Cost' - Cost is a Heading in Column H

Thanks




"RagDyer" wrote in message
...
Your description is confusing, with costs in A196:H266 AND costs in column
H?!?
Plus, what are the ranges that your range names represent?

Also, you're using "Cost.", *with* parenthesis and a decimal?!?

Could you post back with a more accurate description of your data list,
and
the ranges represented by the range names you're using.


--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"John" wrote in message
...
I'm using the formula below to find Raw Materials that are selected in
Column D, where the RM costs are in a Range A196:H266 in sheet "Master".
The
costs are in Column H; RM are in Column A it returns a #N/A - what am I
doing wrong?



=IF(D9=0,"

",(INDEX(Master!A$196:H$266,MATCH(D9,Products),MAT CH("Cost.",Master!$A$194:$
H$194,))))



"RagDyer" wrote in message
...
To be *Exact*,
Vlookup, Hlookup, and Index-Match combinations can return exact data
without
the list being sorted.

On the other hand the *LOOKUP* function *would* need a sorted list to
return
accurate data.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Manish" wrote in message
...
Yes.

-----Original Message-----
I have a list of Raw Material items in Column A with
their costs associated
with them in Column B. I want to design a recipe module
whereby I select Raw
Materials that go in to Finished products and their
associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted
alphabetically?

Thanks



.

Try either of these.
Enter your sheet names as necessary.

=VLOOKUP(D9,A196:H266,8,0)

=INDEX(H196:H266,MATCH(D9,A196:A266,0))

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"John" wrote in message
...
It was my attempt at a formula RD thats why its probably confusing!

Within the Range A196:H266 the RM name is located in Column A; costs of
these RM's is located in Column H

D9 is the cell I select a Raw Material, thus the cost I want represented is
the cost of that

'Food' is a range name I've set up but think this incorrect in the formula
as it is just a list of Finished Products which is irrevelant in obtaining
the cost of each Raw Material.

I spotted the DOT in 'Cost' - Cost is a Heading in Column H

Thanks




"RagDyer" wrote in message
...
Your description is confusing, with costs in A196:H266 AND costs in column
H?!?
Plus, what are the ranges that your range names represent?

Also, you're using "Cost.", *with* parenthesis and a decimal?!?

Could you post back with a more accurate description of your data list,
and
the ranges represented by the range names you're using.


--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"John" wrote in message
...
I'm using the formula below to find Raw Materials that are selected in
Column D, where the RM costs are in a Range A196:H266 in sheet "Master".
The
costs are in Column H; RM are in Column A it returns a #N/A - what am I
doing wrong?



=IF(D9=0,"

",(INDEX(Master!A$196:H$266,MATCH(D9,Products),MAT CH("Cost.",Master!$A$194:$
H$194,))))



"RagDyer" wrote in message
...
To be *Exact*,
Vlookup, Hlookup, and Index-Match combinations can return exact data
without
the list being sorted.

On the other hand the *LOOKUP* function *would* need a sorted list to
return
accurate data.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Manish" wrote in message
...
Yes.

-----Original Message-----
I have a list of Raw Material items in Column A with
their costs associated
with them in Column B. I want to design a recipe module
whereby I select Raw
Materials that go in to Finished products and their
associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted
alphabetically?

Thanks



.

Nah both are returning #N/A

Thanks for looking at it RD


"RagDyer" wrote in message
...
Try either of these.
Enter your sheet names as necessary.

=VLOOKUP(D9,A196:H266,8,0)

=INDEX(H196:H266,MATCH(D9,A196:A266,0))

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"John" wrote in message
...
It was my attempt at a formula RD thats why its probably confusing!

Within the Range A196:H266 the RM name is located in Column A; costs of
these RM's is located in Column H

D9 is the cell I select a Raw Material, thus the cost I want represented
is
the cost of that

'Food' is a range name I've set up but think this incorrect in the formula
as it is just a list of Finished Products which is irrevelant in obtaining
the cost of each Raw Material.

I spotted the DOT in 'Cost' - Cost is a Heading in Column H

Thanks




"RagDyer" wrote in message
...
Your description is confusing, with costs in A196:H266 AND costs in
column
H?!?
Plus, what are the ranges that your range names represent?

Also, you're using "Cost.", *with* parenthesis and a decimal?!?

Could you post back with a more accurate description of your data list,
and
the ranges represented by the range names you're using.


--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"John" wrote in message
...
I'm using the formula below to find Raw Materials that are selected in
Column D, where the RM costs are in a Range A196:H266 in sheet "Master".
The
costs are in Column H; RM are in Column A it returns a #N/A - what am I
doing wrong?



=IF(D9=0,"


",(INDEX(Master!A$196:H$266,MATCH(D9,Products),MAT CH("Cost.",Master!$A$194:$
H$194,))))



"RagDyer" wrote in message
...
To be *Exact*,
Vlookup, Hlookup, and Index-Match combinations can return exact data
without
the list being sorted.

On the other hand the *LOOKUP* function *would* need a sorted list to
return
accurate data.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Manish" wrote in message
...
Yes.

-----Original Message-----
I have a list of Raw Material items in Column A with
their costs associated
with them in Column B. I want to design a recipe module
whereby I select Raw
Materials that go in to Finished products and their
associated costs. Is it
possible to do a LOOKUP if the LOOKUP range in not sorted
alphabetically?

Thanks



.

"John" wrote...
Nah both are returning #N/A
...

Then you don't have an *exact* match for D9 in A196:A266.

"RagDyer" wrote in message
Try either of these.
Enter your sheet names as necessary.

=VLOOKUP(D9,A196:H266,8,0)

=INDEX(H196:H266,MATCH(D9,A196:A266,0))
...

--
To top-post is human, to bottom-post and snip is sublime.