drop down w/ corresponding statement

[eon]

ok here goes, i have a drop down, and what im trying to do is for a specific statement to be filled in a cell depending on the drop down picked

attached is an example

[wmorrison49]

Try putting this where you want the statement to appear:

=IF(C4="Word 1",H3,(IF(C4="Word 2",H4,(IF(C4="Word 3",H5,(IF(C4="Word 4",H6,"")))))))

Let me know if this what you wanted.

[eon]

awesome it works thank you

[wmorrison49]

If you don't want to put the statements in quotes, you can do this too:

=IF(C4=F3,H3,(IF(C4=F4,H4,(IF(C4=F5,H5,(IF(C4=F6,H6,"")))))))

[VBA Noob]

Or a simple vlookup

=VLOOKUP(C4,$F$3:$H$6,3,FALSE)

VBA Noob