Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
the real cell refs are E3, and G3 for my first line due to titles bein in the first 2 rows. I figured i could successfully transpose you formula by altering the cell refs but it doesn't seem to work. Here' what i did to your formula =IF(E4="","",VLOOKUP(E4,$E$3:G3,3,FALSE)) I assumed you skipped the first line on the first E ref in the formul for a reason so i carried the trend throughout and adjusted your A1 t my E3. Also, this cells value is used to calculate a total value based upo the number of peices mis-shipped and this cells value, the cost pe peice. Does this affect anything? Thanks, Dave Corve -- cynder7 ----------------------------------------------------------------------- cynder77's Profile: http://www.excelforum.com/member.php...fo&userid=1537 View this thread: http://www.excelforum.com/showthread.php?threadid=26991 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
The first cell is skipped because it will never be the same as previous
entry, i.e. there is no previous entry. -- HTH RP "cynder77" wrote in message ... the real cell refs are E3, and G3 for my first line due to titles being in the first 2 rows. I figured i could successfully transpose your formula by altering the cell refs but it doesn't seem to work. Here's what i did to your formula =IF(E4="","",VLOOKUP(E4,$E$3:G3,3,FALSE)) I assumed you skipped the first line on the first E ref in the formula for a reason so i carried the trend throughout and adjusted your A1 to my E3. Also, this cells value is used to calculate a total value based upon the number of peices mis-shipped and this cells value, the cost per peice. Does this affect anything? Thanks, Dave Corvec -- cynder77 ------------------------------------------------------------------------ cynder77's Profile: http://www.excelforum.com/member.php...o&userid=15371 View this thread: http://www.excelforum.com/showthread...hreadid=269915 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
If I put the formula you show in G4 (and drag fill down the column), then it
behaves as I would expect it to. If it doesn't do what you described, then I haven't understood what you want to do. -- Regards, Tom Ogilvy "cynder77" wrote in message ... the real cell refs are E3, and G3 for my first line due to titles being in the first 2 rows. I figured i could successfully transpose your formula by altering the cell refs but it doesn't seem to work. Here's what i did to your formula =IF(E4="","",VLOOKUP(E4,$E$3:G3,3,FALSE)) I assumed you skipped the first line on the first E ref in the formula for a reason so i carried the trend throughout and adjusted your A1 to my E3. Also, this cells value is used to calculate a total value based upon the number of peices mis-shipped and this cells value, the cost per peice. Does this affect anything? Thanks, Dave Corvec -- cynder77 ------------------------------------------------------------------------ cynder77's Profile: http://www.excelforum.com/member.php...o&userid=15371 View this thread: http://www.excelforum.com/showthread...hreadid=269915 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|