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

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

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