I have a spreadsheet with various data in different sheets.
I have the following formula =vlookup(modelcode,C52,3) whereby cell C52
contains the name of the sheet to lookup the data. This name is not constant
as various sheet names, e.g. PRIVA, TACTI, CSMAF etc. contain the lookup
data. By using the above formula, it returns the #N/A error. If I substitue
the cell name with the actual sheet name in the formula. e.g. PRIVA, the
formula returns the correct answer. As the sheet name in cell C52 varies, is
it possible for the formula to pick the name of the lookup sheet from cell
C52, rather than me having to enter the actual sheet name every time.

Thanks in advance for any suggestions.

John