Vlookup in VB?
 

Hi
try using MATCH to get the row number:
=VLOOKUP("181006",Inventory!C3:C6,0)

--
Regards
Frank Kabel
Frankfurt, Germany

"Alexthecamel" schrieb im
Newsbeitrag ...
I'm writing some code for a simple VB tool, and have come accross a
problem.

I basically need my code to do a vlookup for a number, then return
the cell
reference for the cell in question.

eg: Find the cell in a given range range containing the number
181006, then
tell me the ref of the cell that is the fifth collumn along.

The vlookup would be:

=VLOOKUP("181006",Inventory!C3:H6,5,FALSE)

If anyone knows, or can point me somewhere i might find the answer i
would
really appreciate it, and you never know, my boss might even let me
leave
before it gets dark tonight. :-)