Help with vlookup, please!

  • Thread starter Thread starter Softkey
  • Start date Start date
S

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
 
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.
 
This is the formula I used but I get #Value
=VLOOKUP(F8&" "&G8,BlockBList&" "&BlockCList,2)

I'm lost, please help.

Thank yo
 
Hi
try the following (array entered with CTRL+SHIFT+ENTER)
=INDEX(BlockCList,MATCH(F8&" "&G8,BlockBList&" "&BlockCList,0))
 
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.
 
Try
=INDEX(BlockCList,MATCH(F8&" "&G8,unitlist!D2:D69&"
"&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
 
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
 
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.
 
Back
Top