Excel Help

**NATEizKING** · 05-10-2012, 10:34 PM

Been since my high school days since I've done much with Excel other than that introductory class at ISU with Word, Excel, Access, and Powerpoint.

I am trying to get a table of fees from sheet2 to coincide with a cell in sheet1 so when I type in a label from sheet2 it will automatically include the fee in sheet1. Sheet2 has a table which has the name of the fee in column A and the fee in column B. I want to take this table from sheet2 and make it so when I type in a name in sheet1 it will automatically include the fee. Thanks ahead of time for the help, I hope I was clear enough in my explanation.

**Jordanj6502** · 05-10-2012, 10:42 PM

MS Excel: Lookup Function

Is this what you are trying to do?

**longtimeclone** · 05-10-2012, 10:49 PM

I was going to suggest a vlookup

MS Excel: VLookup Function

**NATEizKING** · 05-10-2012, 10:50 PM

Originally Posted by Jordanj6502

MS Excel: Lookup Function

Is this what you are trying to do?

That's on the right track though I'm not sure how to get it to work properly. I'll simplify what I was trying to explain.

Sheet2 I made a table: Column A is the Fee Name and Column B is the Fee.

Sheet1 I have a chart: Column A I type in the Fee Name from Sheet2 and want the corresponding Fee from Sheet2 to appear in Column B.

**Jordanj6502** · 05-10-2012, 10:52 PM

So you need to know how to reference between sheets.. give me a sec and I can look that up.

**CycloneErik** · 05-10-2012, 10:52 PM

Are you just importing a total from a cell on one sheet to another sheet?

If so, that's easy. Either jordan or IcSyU showed me how. Well, it's easy now.

**longtimeclone** · 05-10-2012, 10:55 PM

Yeah I am pretty sure that a vlookup formula will work then. You should be able to put the formula in second column so if you type in the name from column A it should fill.

vlookup(column A value of Sheet 1, table from sheet 2, column number with the fee, type "false")

Also when you do the table from sheet 2 make sure you hit f4 to make it so the entire table is always selected.

**Jordanj6502** · 05-10-2012, 10:58 PM

Problem may be that it doesn't work in an unsorted list... I have to take a little bit more time to figure this out...

**NATEizKING** · 05-10-2012, 11:05 PM

Originally Posted by longtimeclone

Yeah I am pretty sure that a vlookup formula will work then. You should be able to put the formula in second column so if you type in the name from column A it should fill.

vlookup(column A value of Sheet 1, table from sheet 2, column number with the fee, type "false")

I understand the cell in sheet1 column B ---> =VLOOKUP(ColumnA value of Sheet1,...)

How do I get the table for the second part of that? Copy paste the entire table?

**NATEizKING** · 05-10-2012, 11:06 PM

Originally Posted by Jordanj6502

Problem may be that it doesn't work in an unsorted list... I have to take a little bit more time to figure this out...

Not in a major rush with it just trying to save some time for the future.

**Jordanj6502** · 05-10-2012, 11:08 PM

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

So Sheet1! means the sheet1 A1 being a reference to the name you typed, the Sheet2!$A$1:$B$5 is the whole table from top left (A1) to bottom right (B5), the 2 is the column with the fee, and 0/False are the same.

The $ in the table makes it static, so you can drag the formula around and still reference the same table.

**longtimeclone** · 05-10-2012, 11:08 PM

When you are putting the formula in you should be able to immediately go to the tab and select the entire table.

When you have it all selected make sure you hit f4 which will make it so the entire table is always selected otherwise if you drag the formula down it will move the table selection down as well.

**NATEizKING** · 05-10-2012, 11:09 PM

Originally Posted by CycloneErik

Are you just importing a total from a cell on one sheet to another sheet?

If so, that's easy. Either jordan or IcSyU showed me how. Well, it's easy now.

I need sheet1 user input in Column A to correspond to sheet2 Column A data, get data value from sheet 2 Column B, and return that value to sheet1 Column B.

**CycloneErik** · 05-10-2012, 11:09 PM

I just use =pagename!cell#

For example =Attendance!E3

I don't know if that would work for you or not. Someone showed it to me, and it's perfect for the little bit I do.

**NATEizKING** · 05-10-2012, 11:20 PM

Originally Posted by Jordanj6502

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

So Sheet1! means the sheet1 A1 being a reference to the name you typed, the Sheet2!$A$1:$B$5 is the whole table from top left (A1) to bottom right (B5), the 2 is the column with the fee, and 0/False are the same.

The $ in the table makes it static, so you can drag the formula around and still reference the same table.

Here is what I'm currently at but it just returns #VALUE:

=VLOOKUP(Invoice!C10,Fee!$A$2:$B$62,Invoice!F10,FALSE)