Elaborate, yeah - I have a workbook that contains a number of worksheets within it. On each sheet there is an IF formula that returns text depending on the result. Further, that result may appear in any cell within a column range (which prevents use of a direct link and the need for a lookup function). Anyway, there is a summary sheet that I use to display this information. Using the LOOKUP formula requires a specific 'Lookup_Value' (ie: the result of the IF formula) but this can change. Hence my problem.
Thanks for the reply. Using an example is probably the easiest way of illustrating it.
So using your example, the problem I have is that the Lookup_Value (ie: 'Lasw10') has 2 possible results. So my Lookup_Value could be either say 'Lasw10' or 'Lasw11' (as determined by the IF formula in the various worksheets). What I need is a formula that will display either the the 'Lasw10' or 'Lasw11' depending on which ever it is.