| View previous topic :: View next topic |
| Author |
Message |
sriniwas67
General User
Joined: 05 Mar 2012
Posts: 9
|
 Posted: Tue Jul 24, 2012 10:45 pm Post subject: REQUEST TO CORRECT MY VLOOKUP FORMULA |
 |
|
Please open the below link to access my sample spreadsheet.
Request someone to correct the vlookup formula used by me, for a particular result described in the spreadsheet. T
The formula is returning the correct results in some cells & errors in others I couldnt figureout as I tried various combinations.
Request someone to help with correction.
https://www.dropbox.com/s/ugrj4dfk7s0fx52/Sample%20List%20for%20vlookup.xls?m |
|
| Back to top |
|
 |
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
| Posted: Wed Jul 25, 2012 12:21 am Post subject: |
|
|
How about:
| Code: | | =IF(COUNTIF($Sheet1.$B$2:$C$196; B2)>0;"del";"ADD") |
The only one different that it finds is ICICIBANK-3M which only exists as ICICIBANK-3M2 on Sheet1.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot) |
|
| Back to top |
|
|
|
