It never has to be in the first row!, or in the first column for that matter.
It depends how you set up your database. If you want to look up pricing,
for example, then it is obvious that your list will contain the criteria -
part number, part description - in the leftmost column of the list, which
could start in Column AA for that matter. What you cannot do, is have your
part number in say column G, and your pricing in colmn B, it will not work.
Similarly, it is not logical to have an address list starting with telephone
numbers in Col A, and then area codes, City, Suburb, Street Address, Street
number in Cols B - F, and the resident's name in col G. After all, you will
always work with the resident, so put it first. That is the known criteria,
the rest is only required on an as and when required basis, therefre they are
to the right of the name column.

"Zygan" wrote:


why is it that when you look up a value using vlookup the value always
has got to be in the first row ? or can i fix this ?


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=548238