Hi, I am working in Tables and when I enter a formula it carries down to all records, however I would like to enter a different formula for 2 sets of data.
The data I wish to lookup relates to States of Australia - I need to have one rule for NSW and another for all other States (classified as "Interstate"), accessing information from 2 separate worksheets. I have tried an IF function but can't quite work out how to make the 2 VLOOKUPS separate.
For example:
NSW - information relates to NSW only and is different to all other States, with info being extracted from a NSW worksheet,
Interstate - information has been collated so that it is consistent for all other States, but has a different outcome to the NSW ones, with info extracted from an Interstate spreadsheet.
Can you help?
