| 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 |
| 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) | |||
Threaded Mode
