Using Lookup function

G

gmwhitehair

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

via135

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

-via135
 
G

Gerry-W

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

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

An example that might help you is: (where a2 refers to the equipmen
name and price_list refers to your table with cost data, and column
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 th
equipment in the table for this to work
 
Top