Z
Zygan
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 ?
has got to be in the first row ? or can i fix this ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
kassie
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.
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.
B
Bondi
Hi Zygan,
You can use a combination of INDEX() and MATCH()
Have a look at this link
http://www.mrexcel.com/tip021.shtml
Regards,
Bondi
You can use a combination of INDEX() and MATCH()
Have a look at this link
http://www.mrexcel.com/tip021.shtml
Regards,
Bondi
D
David McRitchie
Two things to watch out for:
1) is the table sorted or not, if sorted use True; otherwise, False
2) the table itself should be a named table or be addressed with
absolute references.
Vlookup Workdsheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm
1) is the table sorted or not, if sorted use True; otherwise, False
2) the table itself should be a named table or be addressed with
absolute references.
Vlookup Workdsheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm
D
David McRitchie
3) don't mix cells that are all digits with text cells.
Z
Zygan
The reason i ask is because my table needs to look up in two areas for
marketing reasons e.g name is fine, but i would like people with the
postcode of #### to show up and then i can achieve a marketing campaign
on these results like you said kassie the postcode is on a "if required
basis" i had a look at the tip Bondi gave me and it worked well thanks
for the advice all
marketing reasons e.g name is fine, but i would like people with the
postcode of #### to show up and then i can achieve a marketing campaign
on these results like you said kassie the postcode is on a "if required
basis" i had a look at the tip Bondi gave me and it worked well thanks
for the advice all