Using a function with numbers & text
Hi,
If you have over 60 I/O codes, you should probably use VLOOKUP.
If it doesn't already exist, write a 2-column table of input/output codes.
In C1, enter =IF(D1="","",VLOOKUP(D1,AA1:AB60,2,0))
(Where AA1:AB60 is your table - change to suit)
Then copy down.
"Cardslinger" wrote:
I have 6 columns, B has numbers + text (3d, 6c, ad, kd) C has numbers + text
( 3 down, 6 cube, alternate dialog) I want to input into D 6c and have the
return in E be 6 cube, or ad input/alternate dialog output.
I have over 60 input/output codes.
I tried the IF function but it won't work with text. Is there a function
that will accomplish this?
TIA
|