Vlookup formula in excel

T

trisher75

So i am having problems with the formula. I need help i put in the # to look
for, then the range, then the cell to pull info from, but its the True or
False thing thats giveing me problems i think. I am looking for 1126 and in
the range there is a J1126 and a 1126. How do i get it to pull up info for
just the 1126. Help please
 
K

Kenny Anderson

Next time, use the microsoft.public.excel or
microsoft.public.excel.worksheet.functions newsgroups for Excel questions.
This NG is for Microsoft Access.

To answer your question, you probably want "FALSE" for the range_lookup
value. If your lookup_value is 1126 and the first column in your
table_array contains both 1126 and J1126, it will secure the data in the
1126 row. However, be aware that if it doesn't find the exact lookup_value
in the first column of the table_array, you will get the #N/A error value.

If this doesn't answer your question, repost to one of the above newsgroups.
 
T

trisher75

thank you for your help, i am still having problems and i will try and find
those other newsgroups. Kind of new to this and have no idea how to find the
excel groups, it took me almost an hour to find this one.. hahhahaah

Theresa Perkins
 
Top