VLOOKUP, underlying values?

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have a large table of jobs, similar jobs in each row,
with column A describing different areas for each job.
These will all have different rates. I need a lookup
table for the rates. Rather than writing a huge list of
jobs and rates can I write the rates in a similar table or
somehow write the rates underneath each cell so I can do a
VLOOKUP on another worksheet. Hope that made sense.
Thanks.
 
You can create a VLOOKUP table of your tasks down one column and rates down
the column just to the right of the task column on sheet2 and assign a name
to the range and then you can use that RangeName in formulas on your main
sheet to find the rates for each task......for instance, if your list of
tasks and rates were called by the Rangename "TasksAndRates" on sheet 2 and
on your main sheet 1 your task was in cell A2, then in B2 you could put the
formula
=VLOOKUP(A2,RATESANDTASKS,2,FALSE) and it will automatically look up that
rate for you.....

If you have more trouble, just post back with more specifics, and someone
will help......

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top