| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What am I doing wrong
vLookup Problem never ceases
Dear someone Im having a problem with a vlookup formula, with (last cell/row always varying) what do I do to copy the last cell with data and paste it to another sheet. This formula below finds the first sum not the last. Or Is there another way to copy last cell with data and paste to another sheet? =IF(ISNA(VLOOKUP(A5,Employee1!$A$5:$AF$32,32,FALSE )),"",VLOOKUP(A5,Employee1!$A$5:$AF$32,32,FALSE)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| Any wrong with this? | Excel Discussion (Misc queries) | |||
| i did something wrong | Excel Discussion (Misc queries) | |||
| Min Max What's Wrong? | Excel Worksheet Functions | |||
| What am I doing wrong? | Excel Discussion (Misc queries) | |||
Threaded Mode
