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

The syntax for VLOOKUP (exact match) is =VLOOKUP(what-to-look-for-1st column-of-the-lookup-range,lookup-range,column-number-in-the-range, false)
Now if you want to retrieve a series of adjacent cells this is possible with an array formula.
Eventually post a sample sheet?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks, I quickly wrote some sample data to see if I was doing it correctly and I was so I think the problem is with the columns of data. The result I am after is formatted as general and the source data is formatted as text - would this result in #N/A? And if so how would I over come it?

Thanks

Post a small sample so we can have a look?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi,
I got the Vlookup working by creating linked cells of the data and standardising it to "text" filtering out the content I didn't want. Seems to work really well