Hi There hope you are all OK. I've been scratching my head about this and wondered if anyone could help. I am trying to build a supplier database which will look for a town name and category then return a supplier which matches both criteria so for example if I enter 'Bolton' in A1 and 'Fire' in A2 in two cells it will go to the raw data and return 'Bolton Fire Supplies' in A3. I can't seem to work out how to do it. Anyone got any ideas?

All help much appreciated. I'm sure its something obvious but I can't see the wood for the trees!