data validation auto complete

**metaphysic** · 07-15-2010, 02:38 PM

i want to do next

when i want to select "b" (from cell E6) in drop down in cell A3

i want get automatic from excell in cell B3 value "2" (from cell F6)

\1

Thank you a lot

**zbor** · 07-15-2010, 02:42 PM

Try VLOOKUP function:

=VLOOKUP(B2, E5:F7, 2)

**NBVC** · 07-15-2010, 02:45 PM

=Lookup(A3,E5:F7) if the E5:E7 list is in sorted ascending order. If not,

=Vlookup(A3,E5:F7,2,0)

**metaphysic** · 08-02-2010, 10:36 AM

Thank You for answer, but where i do error

in the case with value is corect a,b,c,d,e

but when i try with real value what i want there is error

**NBVC** · 08-02-2010, 08:29 PM

Since your list in column M is not in sorted ascending order, you need to use my 2nd option:

e.g. =VLOOKUP(J4,M4:N7,2,0)

**metaphysic** · 08-03-2010, 02:24 PM

Thank you a lot, thats it my english is not enought good so its probelm too

and please write me if you know,
if item is not present in the table, it returns #N/A.
how to remove #N/A. i was find something but is not usefull,
as =IF(ISERR(VLOOKUP...... ???