Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programing a vlookup
Ok here is what i haveI not sure if or how this can be done. I need to look
in the first row on a sheet named Modem for serNum, INT Remit and then look for a sheet that will be named LPMI or Combined LPMI, look in row one for NUM# total due. Here is how the vlookup goes ServNUm to Num# Total due - int Remit Then after the vlookup I need to find on the modem tab tot Remit, Prinremit in row one and add PrinRemit and intRemit and put the total in totRemit. I could really use the help on this Im not even sure where to start. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programing a vlookup
jln,
Yes, anything can be done in VBA. But for us to help, you need to better describe your problem.... are you trying to find the string "serNum" or is it a value in the first row? What is Num#? Post short examples of your data tables, the steps that you would take manually, and an example of what you expect to get back from the routine. HTH, Bernie MS Excel MVP "jln via OfficeKB.com" <u25956@uwe wrote in message news:678e49845aa27@uwe... Ok here is what i haveI not sure if or how this can be done. I need to look in the first row on a sheet named Modem for serNum, INT Remit and then look for a sheet that will be named LPMI or Combined LPMI, look in row one for NUM# total due. Here is how the vlookup goes ServNUm to Num# Total due - int Remit Then after the vlookup I need to find on the modem tab tot Remit, Prinremit in row one and add PrinRemit and intRemit and put the total in totRemit. I could really use the help on this Im not even sure where to start. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VB Programing | Excel Programming | |||
Programing help | Excel Programming | |||
VB programing | Excel Programming | |||
Help with VBA programing | Excel Programming | |||
programing book | Excel Programming |