Hi,

Im not sure if vlookup is the best method or even if Im going about it incorrectly.

I have 2 sheets - sheet 1 is where the data is entered and sheet 2 is where the data to select from is located (and will be hidden)

I have a drop down which selects a value from sheet 2 and places it into sheet 1. What Im then trying to do is get other records relating to that selected record and populate it in a different cell - would I use a vlookup for this and if so how because when Ive tried it returns #N/A

The code used is Sheet1Q:Q is the value I want
Sheet1!B12,Sheet1!A:A is the value which relates to the value I want
FALSE as I understand is it that I want an exact match?

Thanks