vlook up and return formula

[JE]

Is it possible to use vlookup to return a formula? Here is my scenario:

Spreadsheet 1

Column A Column B Column C
Equity C ABC123
Muni 912822xd
Moneymkt 8145332x
Option jpm-42

Spreadsheet 2

Column A Column B Column C Column D
Equity concatenate(B2,"
","EQUITY")
Muni concatenate(C2,"
","GOVT")
Moneymkt concatenate(C2,"
","GOVT")
Option concatenate(B2,"
","OPT")

My goal is to vlookup in spreadsheet 1 on column a and return from
spreadsheet 2 the formula in column D.

Many thanks

 

[Pete_UK]

I don't know why you need to do it that way - put this in D1 of
Sheet1:

=IF(A1="Equity",B2&" EQUITY",IF(OR(A1="Muni",A1="Moneymkt"),C2&"
GOVT"),IF(A1="Option",B2&" OPT","")))

then copy it down as required.

Hope this helps.

Pete

 

[Greg Wilson]

Pete, I believe your formula has an erroneous parenthesis after C2&"GOVT". I
think you meant this:
=IF(A1="Equity",B2&"
EQUITY",IF(OR(A1="Muni",A1="Moneymkt"),C2&"GOVT",IF(A1="Option",B2&"
OPT","")))

Cheers,
Greg

 

[Pete_UK]

Yes, thanks for pointing that out, Greg.

Pete

Pete, I believe your formula has an erroneous parenthesis after C2&"GOVT".. I
think you meant this:
=IF(A1="Equity",B2&"
EQUITY",IF(OR(A1="Muni",A1="Moneymkt"),C2&"GOVT",IF(A1="Option",B2&"
OPT","")))

Cheers,
Greg








- Show quoted text -