Help with vlookup, please!

[Softkey]

Hi,

Can anyone help me, I got 2 drop down lists A1, B1, what I want i
lookup on either one of those lists and return the number at C1.
I can do for A1 or B1 but not combined, don't know how to add th
second list to the function

 

[Norman Harker]

Hi Softkey!

Use:

=A1&B1

Most likely you'll want:

=A1&" "&B1

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Softkey]

This is the formula I used but I get #Value
=VLOOKUP(F8&" "&G8,BlockBList&" "&BlockCList,2)

I'm lost, please help.

Thank yo

 

[Frank Kabel]

Hi
try the following (array entered with CTRL+SHIFT+ENTER)
=INDEX(BlockCList,MATCH(F8&" "&G8,BlockBList&" "&BlockCList,0))

 

[Norman Harker]

Hi Soft Key!

You're very confused.

Give details of what sort of data you have in B1 and C1

You might also do a Google Search on VLOOKUP and you'll find plenty of
examples of how it is used. Download Ron de Bruin's Google Search 6.0
Addin and you'll find that searches are very easily made from within
Excel. Obtain it (free) complete with user guide from:

http://www.rondebruin.nl/Google.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Softkey]

Here is the link to the doc.

http://www.canadianbyte.com/excel/time_sheet1.xls

maybe this will bring a bit of light.

Thanx guy

 

[Frank Kabel]

Try
=INDEX(BlockCList,MATCH(F8&" "&G8,unitlist!D269&"
"&unitlist!A2:A68,0))
though i#m not sure which column of the sheet unitlist you want to
return. Also your first example row will return an error as no match
exist for this combination of lookup values

 

[Softkey]

Thank you guys for your answers.
I've deleted one column and combine both lists, add a simple vlooku
but the results are not right.
Ok, what I want is choose a unit # and get the block for that uni
which in this case is B or C, that's all.
The worksheet in that link is been updated.

Than

 

[Norman Harker]

Hi SoftKey!

Looks all right to me. It's looking up your number 2765 in the list
and returning the letter C. Why should it return differently?

It doesn't look as though you have any duplicates in your numbers.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.