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 |