Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Which function do I need?
I'm sure there is a function in excel to do what I want to do, I just don't
know what that is. I was hoping you could help me. I have a table set up for daily fuel prices on sheet 1. Column A is the date, Columns B-I are different locations. (Row 1 is my headings, data is compiled in rows 2-100). On sheet two, I've entered a date in Col.A, and the heading "Location" in Col.B where I type a location that matches the headings on Sheet 1, Col.B-I. In Col.C, Sheet 2, I want a lookup function of some sort to return the value from the cell that intersects the date/location from sheet 1. I've tried several things, including embedding vlookup in hlookup but that just keeps sending me around in circles. I know this can be done. Could you please tell me how to do it? Thanks! Loni Loni |
#3
|
|||
|
|||
Try
=vlookup(A1,sheet1!$A$1:I100,match(B1,sheet1!$A$1: $I$100)) "Loni - RWT" wrote: I'm sure there is a function in excel to do what I want to do, I just don't know what that is. I was hoping you could help me. I have a table set up for daily fuel prices on sheet 1. Column A is the date, Columns B-I are different locations. (Row 1 is my headings, data is compiled in rows 2-100). On sheet two, I've entered a date in Col.A, and the heading "Location" in Col.B where I type a location that matches the headings on Sheet 1, Col.B-I. In Col.C, Sheet 2, I want a lookup function of some sort to return the value from the cell that intersects the date/location from sheet 1. I've tried several things, including embedding vlookup in hlookup but that just keeps sending me around in circles. I know this can be done. Could you please tell me how to do it? Thanks! Loni Loni |
#4
|
|||
|
|||
Thanks for replying! I tried that, but it kept giving me an "#N/A" error.
Any suggestions? Thanks, Loni "bj" wrote: Try =vlookup(A1,sheet1!$A$1:I100,match(B1,sheet1!$A$1: $I$100)) "Loni - RWT" wrote: I'm sure there is a function in excel to do what I want to do, I just don't know what that is. I was hoping you could help me. I have a table set up for daily fuel prices on sheet 1. Column A is the date, Columns B-I are different locations. (Row 1 is my headings, data is compiled in rows 2-100). On sheet two, I've entered a date in Col.A, and the heading "Location" in Col.B where I type a location that matches the headings on Sheet 1, Col.B-I. In Col.C, Sheet 2, I want a lookup function of some sort to return the value from the cell that intersects the date/location from sheet 1. I've tried several things, including embedding vlookup in hlookup but that just keeps sending me around in circles. I know this can be done. Could you please tell me how to do it? Thanks! Loni Loni |
#5
|
|||
|
|||
I goofed up in the match section. try
=vlookup(A1,sheet1!$A$1:I100,match(B1,sheet1!$A$1: $A$100)) "Loni - RWT" wrote: Thanks for replying! I tried that, but it kept giving me an "#N/A" error. Any suggestions? Thanks, Loni "bj" wrote: Try =vlookup(A1,sheet1!$A$1:I100,match(B1,sheet1!$A$1: $I$100)) "Loni - RWT" wrote: I'm sure there is a function in excel to do what I want to do, I just don't know what that is. I was hoping you could help me. I have a table set up for daily fuel prices on sheet 1. Column A is the date, Columns B-I are different locations. (Row 1 is my headings, data is compiled in rows 2-100). On sheet two, I've entered a date in Col.A, and the heading "Location" in Col.B where I type a location that matches the headings on Sheet 1, Col.B-I. In Col.C, Sheet 2, I want a lookup function of some sort to return the value from the cell that intersects the date/location from sheet 1. I've tried several things, including embedding vlookup in hlookup but that just keeps sending me around in circles. I know this can be done. Could you please tell me how to do it? Thanks! Loni Loni |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |