Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup problem - unable to get the vlookup property
Hi
I've been reading posts and trying all kinds of things with no luck. Dim Char23PayorName as String Dim SumRW as Integer 'using the current row Char23PayorName = Application.VLookup(Range("A" _ & SumRW).Value, "Payor_Payee!A2:D10000", 4, False) I think the problem is in that the value returned for the lookup value is text and not a number. When debugging, it is showing the lookup value as "Nameabc". The result of this formula will be text. I have restructrued the code to put a formula in a cell. However, the #NAME? error is returned from the formula. The formula in that cell reads: =vlookup(Nameabc, Payor_Payee!A2:D10000, 4, False). If I put quotation marks around the vlookup value in the formula "Nameabc", then it works. Please help while I still remain somewhat sane. Thanks Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup problem - unable to get the vlookup property
Hi,
Try this Char23PayorName = Application.VLookup(Range("A" & SumRW).Value, _ Range("Payor_Payee!A2:D10000"), 4, False) Mike "Fred" wrote: Hi I've been reading posts and trying all kinds of things with no luck. Dim Char23PayorName as String Dim SumRW as Integer 'using the current row Char23PayorName = Application.VLookup(Range("A" _ & SumRW).Value, "Payor_Payee!A2:D10000", 4, False) I think the problem is in that the value returned for the lookup value is text and not a number. When debugging, it is showing the lookup value as "Nameabc". The result of this formula will be text. I have restructrued the code to put a formula in a cell. However, the #NAME? error is returned from the formula. The formula in that cell reads: =vlookup(Nameabc, Payor_Payee!A2:D10000, 4, False). If I put quotation marks around the vlookup value in the formula "Nameabc", then it works. Please help while I still remain somewhat sane. Thanks Fred |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup problem - unable to get the vlookup property
Auuugggghhhhh! So close!
Thanks Mike, works great! "Mike H" wrote: Hi, Try this Char23PayorName = Application.VLookup(Range("A" & SumRW).Value, _ Range("Payor_Payee!A2:D10000"), 4, False) Mike "Fred" wrote: Hi I've been reading posts and trying all kinds of things with no luck. Dim Char23PayorName as String Dim SumRW as Integer 'using the current row Char23PayorName = Application.VLookup(Range("A" _ & SumRW).Value, "Payor_Payee!A2:D10000", 4, False) I think the problem is in that the value returned for the lookup value is text and not a number. When debugging, it is showing the lookup value as "Nameabc". The result of this formula will be text. I have restructrued the code to put a formula in a cell. However, the #NAME? error is returned from the formula. The formula in that cell reads: =vlookup(Nameabc, Payor_Payee!A2:D10000, 4, False). If I put quotation marks around the vlookup value in the formula "Nameabc", then it works. Please help while I still remain somewhat sane. Thanks Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unable to get the VLookup property of the WorksheetFunction class | Excel Discussion (Misc queries) | |||
Vlookup property missing | Excel Programming | |||
Unable to get the Vlookup property of the WorksheetFunction class | Excel Programming | |||
Unable to get the Vlookup Property of the WorkSheetFunction Class | Excel Programming | |||
Unable to get VLOOKUP property | Excel Programming |