text reference to cell...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brinded - 29 Apr 2008 04:10 GMT

I have column of entries, each of which has a cell with text
consisting of a few letters, either 'DPA', 'DP', 'ST'

I'd like to make a formula where the text points to a value given in
another cell - a key as it were.

something like =IF(B1='DPA',$X$10)

since I can't get a formula to 'lookup' a key, is there an easier way
of doing this?

thanks

Reply to this Message

brinded - 29 Apr 2008 04:19 GMT

I should add, there are only four text codes, each representing a
whole number, so the lookup would be really simple:

DPA 10
DP 20
ST 32
DG 42

Reply to this Message

JE McGimpsey - 29 Apr 2008 11:53 GMT

In article
<2496449e-bd3e-458a-a6e5-ceaf600d25c5@l28g2000prd.googlegroups.com>,

> I should add, there are only four text codes, each representing a
> whole number, so the lookup would be really simple:
[quoted text clipped - 3 lines]
> ST 32
> DG 42

If the lookup table above were in, say, Sheet2!A1:B4, then one way:

=VLOOKUP(B1,Sheet2!$A$1:$B$4,2,FALSE)

or, if B1 may contain something other than the four values:

=IF(ISNA(MATCH(B1,Sheet2!$A$1:$A$4,FALSE), "", VLOOKUP(B1,
Sheet2!$A$1:$B$4,2,FALSE))

Reply to this Message

Mac Forum / Applications / Excel / April 2008

text reference to cell...