As long as the rows are in increasing order in column A I'm not sure why
it would return a value from a different row. Changing the order of the
columns would cause a problem but this can be rectified by changing the
last part of the formula. e.g. the part of the formula that says
column(b100) returns the value 2 as column B is the 2nd column. The
vlookup therefore looks 2 columns over to get the result. So say it
looks up the value 100 and finds it in A8, it counts across 2 columns
(including column A) which gives the value in B8.
Give me a bit more info about the validation you refer to, and also the
bit about 'only returned one value'.

compconnj Wrote:
Thanks for your reply. Initially, it worked but then I added a 3rd
sheet and used data from the 3rd sheet as validation for one of the
columns that the VLOOKUP function referenced. When I did this, the
VLOOKUP only returned one value and not the corresponding value of the
correct row. Any ideas on how I can get around this issue? Is part of
the problem that I changed the order of the columns in Sheet1 so they
don't match the order on Sheet2? Thanks.


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=524864