Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup in VB?
=VLOOKUP("181006",Inventory!C3:H6,5,FALSE)
try myrange=sheets("Inventory").range("c3:h6") range("b3") =VLOOKUP("181006",myrange,5,FALSE) -- Don Guillett SalesAid Software "Alexthecamel" wrote in message ... 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. :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |