Quote:
Originally Posted by Pecoflyer
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?
|
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