Looking up information and returning a value
Hi
On sheet2, in cell E1
=IF($D1="","",VLOOKUP($D1,Sheet1!$A$1:$B$100,2,0))
Copy down as required
--
Regards
Roger Govier
"Camp7640" wrote in message
...
I have an Excel worksheet where I'm trying to display a value in a
field
based on the state selected in another field.
For example if the state is TX, the value is 100, if the State is FL,
the
value is 120 etc.
I have the states listed on a worksheet in column A and the
corresponding
values in column B.
Then I set up the second worksheet, same workbook with my other
information.
On this worksheet I want to select a state from a drop down (which
I've
done) and based on that selection populate the next cell (i.e. E1)
with the
appropriate value based on my look up table.
How do I do this?
Your help is much appreciated.
|