Lookup Table?

[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

 

[Frank Kabel]

Hi
have a look at VLOOKUP. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[firefytr]

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

 

[MAX258]

Thanks Zach and Frank,

I think that is gonna work for me.

Regards,
Ma