IF/Vlookup in Excel 07

[JMer811]

Hi All,
I'm looking for a formula that says: If column A is populated with these values (PSO,FSO), than run a vlookup on this sheet. If not run a vlookup on another sheet.
Is this possible and how would this look.

Thanks for the help.

-J

[daddylonglegs]

Try something like

=IF(OR(A2={"PSO","FSO"}),vlookup1,vlookup2)

replace the vlookups with the specific formulas you need

[JMer811]

This worked! Thank you so much!