Ok for the most part it works. If I change A5(from Butter to another it may
or may not give me the right info. If I out another column like B5(and make
it a number 1.2.3.4.5 etc and then number next to C3 in B3 a number it gives
em the exact number every time. How do i fix the text part soit doest it
every time?

"NickHK" wrote:

=VLOOKUP(A5,C3:F4,2,TRUE)

NickHK

"Khanjohn" wrote in message
...
I know how this works and why

=index(CostList!$A$1:$E$200,Match($A54,CostList!$A $1:$A$200,0),Match($M$1,Co
stList!$A$1:$E$1,0))
but now I have confused my self to the point i can not progress. What I
need
to do is look up a single Cell, Match it to a column and then get the
result from the next column. Like Following.

A5 Butter C3 Milk 2
D3 Cream 14
E3 Butter
7
F3 Cheese 3

B5 Result (7).

I have tried Lookup, VLOOKup etc and nothign happens. Any help to Unstick
me
as I am nto starting to do alot of single lookup verse 1 to many columns.
BTW
the result shold be 7. I dont need the (). I have no problem with
matching
2 items liek above but single have me stumped. Thanks in advance.