| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF/VLOOKUP Query
Hi all, I'm trying to check to two spreadsheets for the presence of similar project names. I thought I could do this using a combination of IF and VLOOKUP: =IF(VLOOKUP(A2,'[Barclays & Woolwich Retail Tracker 3.3.xls]Programme (High Level)'!$A$190:$D$283,2,FALSE)=A2,"Y","N") To clarify: A2 is the project name $A$190:$D$283,2 is the range to the VLOOKUP, second column. I keep getting an N/A result on this though. Any suggestion to what I'm doing wrong? TIA, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=568239 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF/VLOOKUP Query
Why not just try
=IF(SUMPRODUCT(--('[Barclays & Woolwich Retail Tracker 3.3.xls]Programme (High Level)'!$B$190:$B$283)=A2)0,"Y","N") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "SamuelT" wrote in message ... Hi all, I'm trying to check to two spreadsheets for the presence of similar project names. I thought I could do this using a combination of IF and VLOOKUP: =IF(VLOOKUP(A2,'[Barclays & Woolwich Retail Tracker 3.3.xls]Programme (High Level)'!$A$190:$D$283,2,FALSE)=A2,"Y","N") To clarify: A2 is the project name $A$190:$D$283,2 is the range to the VLOOKUP, second column. I keep getting an N/A result on this though. Any suggestion to what I'm doing wrong? TIA, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=568239 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF/VLOOKUP Query
Thanks Bob. -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=568239 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems importing from an Access query | Excel Discussion (Misc queries) | |||
| changing query source | Excel Worksheet Functions | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| "Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Linear Mode
