If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|