Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Looking up data from a table conditionally
Hello,
I would like to know how to create a formula that looks at a value in one cell, uses that value to find a corresponding value in a separate table, and then enters that value in my sheet. For example, say I want a value to appear in cell B1 based on the value in cell A1. If the value in cell A1 is "B", and the value in a separate table that corresponds to "B" is $500, I want the formula in cell B1 to return the value "$500". Any ideas on how to do this? Thanks, Eric |
#2
|
|||
|
|||
Classic application for the VLOOKUP formula.........
=VLOOKUP(A1,YOURTABLE,2,FALSE) Where "YOURTABLE" is a named range of two columns listing your values to be looked up on the left and the results on the right........ie: D1:E5 Vaya con Dios, Chuck, CABGx3 "Eric Stephens" wrote in message ... Hello, I would like to know how to create a formula that looks at a value in one cell, uses that value to find a corresponding value in a separate table, and then enters that value in my sheet. For example, say I want a value to appear in cell B1 based on the value in cell A1. If the value in cell A1 is "B", and the value in a separate table that corresponds to "B" is $500, I want the formula in cell B1 to return the value "$500". Any ideas on how to do this? Thanks, Eric |
#3
|
|||
|
|||
Thanks, Chuck! I had forgotten about the VLOOKUP command.
Eric "CLR" wrote: Classic application for the VLOOKUP formula......... =VLOOKUP(A1,YOURTABLE,2,FALSE) Where "YOURTABLE" is a named range of two columns listing your values to be looked up on the left and the results on the right........ie: D1:E5 Vaya con Dios, Chuck, CABGx3 "Eric Stephens" wrote in message ... Hello, I would like to know how to create a formula that looks at a value in one cell, uses that value to find a corresponding value in a separate table, and then enters that value in my sheet. For example, say I want a value to appear in cell B1 based on the value in cell A1. If the value in cell A1 is "B", and the value in a separate table that corresponds to "B" is $500, I want the formula in cell B1 to return the value "$500". Any ideas on how to do this? Thanks, Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |