Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up
Hi
I want to know if i can combine the following two formulas into one. I have two spreadsheets in the same work book. I want column B of spreadsheet 2 to compare with column B of spreadsheet 1 to see if the code exists. If the code exists i want comment located in column E of spreadsheet 1 to show in column E of spreadsheet 2. Make sense? =VLOOKUP(B1,'9-6-09'!B:B,1,FALSE) =IF(E1='9-6-09'!B1,'9-6-09'!E1,"null") Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up
Try the below and feedback
=IF(ISNA(VLOOKUP(B1,'9-6-09'!B:E,4,FALSE)),"Null",VLOOKUP(B1,'9-6-09'!B:E,4,FALSE)) OR using MATCH() =IF(ISNA(MATCH(B1,'9-6-09'!B:B,0)),"Null",INDEX('9-6-09'!E:E,MATCH(B1,'9-6-09'!B:B,0)) If this post helps click Yes --------------- Jacob Skaria "Youngy5" wrote: Hi I want to know if i can combine the following two formulas into one. I have two spreadsheets in the same work book. I want column B of spreadsheet 2 to compare with column B of spreadsheet 1 to see if the code exists. If the code exists i want comment located in column E of spreadsheet 1 to show in column E of spreadsheet 2. Make sense? =VLOOKUP(B1,'9-6-09'!B:B,1,FALSE) =IF(E1='9-6-09'!B1,'9-6-09'!E1,"null") Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up
Put this in E1 of sheet2:
=IF(ISNA(MATCH(B1,'9-6-09'!B:B,0)),"not present","present") then copy down. Hope this helps. Pete On Jun 17, 8:03*am, Youngy5 wrote: Hi I want to know if i can combine the following two formulas into one. *I have two spreadsheets in the same work book. *I want column B of spreadsheet 2 to compare with column B of spreadsheet 1 to see if the code exists. *If the code exists i want comment located in column E of spreadsheet 1 to show in column E of spreadsheet 2. *Make sense? =VLOOKUP(B1,'9-6-09'!B:B,1,FALSE) =IF(E1='9-6-09'!B1,'9-6-09'!E1,"null") Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|