Using Lookup function
 

:confused: 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

Using Lookup function
 

There is no attached worksheet!

Try it again!

Biff

"gmwhitehair"
wrote in message
...

:confused: 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

Using Lookup function
 

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

-via135



gmwhitehair Wrote:
:confused: 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.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=529397

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.