Search : in
By :

Both rows and columns lookup

Last answer on Jun 18, 2009 12:18:42 am BST mine, on Jun 17, 2009 6:59:06 pm BST 
 Report this message to moderators

Hello,
Can anyone please help me on how to set up a formula for both rows and column lookup?

here's an example
Fruit Price1 Price2
Apples 0.69 0.65
Bananas 0.34 0.37
Lemons 0.55 0.54
Oranges 0.25 0.26

Example:
In my input tab, i have the folowing

Fruit : Lemons
Price: Price2
Result: (lookup formula that will give me 0.54)

Thanks!

Configuration: Windows XP Internet Explorer 7.0

Best answers for « both rows and columns lookup » in :
[Excel] Sorting rows only Show[Excel] Sorting rows only Microsoft Excel by default perform a sort on the columns (Data/Sort). To sort the data horizontally, just select the data to be sorted, then Data tab /Sort/ Options/ check the Sort Left to right box in the...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Declaring a style sheet (CSS) ShowDeclaring a style sheet Style sheets are not directly integrated into the W3C's HTML recommendations. For this reason, you need to include elements in the HTML code indicating both the type of document, meaning the version of the HTML and CSS...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

 venkat1926, on Jun 18, 2009 12:18:42 am BST

Put inA10 lemons
and B10 this formula

=VLOOKUP($A10,$A$1:$C$5,COLUMN($C$1),FALSE)

if you want prsice1 you change the thrid argument from 3 to 2.

assuming your data is in
a1 to c5 including column headaers.

   
Reply to venkat1926
Ask your question Reply
They need your help