Feb 16 2021 11:39 PM
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?
Feb 17 2021 12:01 AM
@Sue_H1160 Try something like:
=IF([@State]="NSW",<VLOOKUP function NSW>,<VLOOKUP function for Interstate>)
assuming you work with a structured table where the column for the state is called "State".