Lookup Table?

  • Thread starter Thread starter MAX258
  • Start date Start date
M

MAX258

Good Morning,

I'm not really sure what function I am looking for, but here is what
am trying to do. I have a worksheet with Names in one column, an
associated rates in another column. This worksheet is basically a rat
lookup table worksheet.

Each month I get new data in another worksheet, and the rate column i
blank, so I have to manually go to the rate lookup worksheet, and ente
the rate into the new worksheet.

Is there a function I can use to point to the lookup table so that
don't have to manually look up, and enter the rate each month?

Thanks in advance,
Ma
 
assuming your data is desiring to be looked up on sheet2 and all you
information is on sheet 1, you may want to take a look at th
following:

we'll say in B1...

=VLOOKUP(A1,Sheet1!$A$1:$B$100,2,0)

change ranges to suit. the zero type-set on the end will find an exac
match. if none are found, results will be the #N/A error. for option
ridding that, check out this link:

http://www.mrexcel.com/board2/viewtopic.php?t=6210
 
Back
Top