|
| 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
December 21st, 2009, 03:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Lookups?
I'm trying to create a formula that will lookup the what is in column G in
column B of another sheet. If what is in column G is in column B of the other sheet, the word NEW is returned, otherwise the cell is left blank (""). Any help? Thanks! 
|
|
#2
December 21st, 2009, 03:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookups?
One grasp, and a way to have it done ...
In Sheet2, Assuming data in B2 down you could place this in C2: =IF(COUNTIF(Sheet1!G:G,B2),"New","") and copy it down to return the required results. Success? hit the YES below -- Max Singapore --- "lightbulb" wrote: I'm trying to create a formula that will lookup the what is in column G in column B of another sheet. If what is in column G is in column B of the other sheet, the word NEW is returned, otherwise the cell is left blank (""). Any help? Thanks!
|
|
#3
December 21st, 2009, 03:24 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookups?
This did not work. I want it to say new in column W of sheet 2 if G9 on
sheet 2 appears anywhere in column B on sheet 1. More help? "Max" wrote: One grasp, and a way to have it done ... In Sheet2, Assuming data in B2 down you could place this in C2: =IF(COUNTIF(Sheet1!G:G,B2),"New","") and copy it down to return the required results. Success? hit the YES below -- Max Singapore --- "lightbulb" wrote: I'm trying to create a formula that will lookup the what is in column G in column B of another sheet. If what is in column G is in column B of the other sheet, the word NEW is returned, otherwise the cell is left blank (""). Any help? Thanks!
|
|
#4
December 21st, 2009, 03:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookups?
In Sheet2,
In say, W9: =IF(COUNTIF(Sheet1!B:B,G9),"New","") That should do it ok. Success? hit the YES below, let me know -- Max Singapore --- "lightbulb" wrote: This did not work. I want it to say new in column W of sheet 2 if G9 on sheet 2 appears anywhere in column B on sheet 1. More help?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
