vlookup

[Spooner]

this seems like a simple excel question

i have a table in one tab with categories and their corresponding rates

i have a bigger spreadsheet in another tab and i want it for when i input a particular category, the next column returns the rate.

how do i set this up?

 

[WildHorse]

Select the area with the categories and their corresponding rates, and give that area a name.
Have your values which are to be found during lookup in the left column of that named area.

In the other spreadsheet, its just this:
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

It's very simple when you actually do it, because in Excel you just click the Formula /Reference & Lookup wizard, and it'll walk you through the steps.

 

[brandonbull]

select INSERT > Function > vlookup

first value: is the cell you want the matching value from the source table
second value: is the range of the source table. must absolute reference source table row numbers.(ex. a$1:b$5) two columns
third value: is the column the value you are looking for is in the source table. the example above it would be "2" because the desired values are in column b.