Using Lookup function

[gmwhitehair]

I am trying to insert a lookup function in the attached "Equipment" worksheet. I would like to enter the name of a piece of equipment in the column labeled "Equipment"(in green) and have it search the table of info and return the cost of the named equipment in the "Hourly Total" column (in orange). I tried using the VLookup function which seems should work, but it did not. I hope this is enough info. Any assistance would be greatly appreciated. Thanks.

[Biff]

There is no attached worksheet!

Try it again!

Biff

"gmwhitehair" <[email protected]>
wrote in message
news:[email protected]...
>
> I am trying to insert a lookup function in the attached
> "Equipment" worksheet. I would like to enter the name of a piece of
> equipment in the column labeled "Equipment"(in green) and have it
> search the table of info and return the cost of the named equipment in
> the "Hourly Total" column (in orange). I tried using the VLookup
> function which seems should work, but it did not. I hope this is
> enough info. Any assistance would be greatly appreciated. Thanks.
>
>
> --
> gmwhitehair
> ------------------------------------------------------------------------
> gmwhitehair's Profile:
> http://www.excelforum.com/member.php...o&userid=33126
> View this thread: http://www.excelforum.com/showthread...hreadid=529397
>

[via135]

i can't find attached either a "worksheet" or a "workbook" or a "file"
kindly attach and get the solution???

-via135

I am trying to insert a lookup function in the attached "Equipment" worksheet. I would like to enter the name of a piece of equipment in the column labeled "Equipment"(in green) and have it search the table of info and return the cost of the named equipment in the "Hourly Total" column (in orange). I tried using the VLookup function which seems should work, but it did not. I hope this is enough info. Any assistance would be greatly appreciated. Thanks.

[Gerry-W]

Vlookup is very particular in its method. You must be searching for an
item in a range of cells and tell it to return you the info in the
selected column of the range.

Vlookup does not deal well with duplicates in ranges, it will return
the first value it finds.

An example that might help you is: (where a2 refers to the equipment
name and price_list refers to your table with cost data, and column 5
contains the cost amount you are looking for)

=vlookup(a2, price_list,5,false)

note that the spelling of equipment in A2 must match the spelling the
equipment in the table for this to work.


--
Gerry-W