Lookup?

S

sssb2000

Well-known Member
Joined
Aug 17, 2004
Messages
1,169
hi, i have a column (A) with a bunch of "K"s in it....scattered through 150k rows.

in column B, i have values for every row.


What formula in C1 will search col. A and return B values for All "T"s in column A?

thanks in advance for any help.
 
Sort by date Sort by votes
Hope you can figure out how to setup macros and VBA in version 2007. Is it a permissions thing or you just haven't found it yet?
 
Upvote 0

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
i'm not sure actually......
how can i check to see if it's a permission thing?
i know that they installed the full version for me....but ever since i got it, macros are OFF! and nothing i do seems to turn them on :(

it's even worse because 07 is so new that nobody here or on other sites has real information on questions like that...
 
Upvote 0
If it was a permissions issue, you would get a prompt that you are not allowed to make that change.
Please post any solution you find here. I will post back if I find out anything.
 
Upvote 0
Take a look at this link.
http://www.directionsonmicrosoft.com/sample/DOMIS/update/2006/06jun/0606ccmto2.htm

Snippet below:
Macros Excluded from Files

Documents saved in Office 2007's default format cannot contain macros. This measure makes Office 2007 less susceptible to macro viruses carried in documents, but it could also affect existing macros that organizations have deployed by distributing documents
Click to expand...

This may help too:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=579519&SiteID=17
You need to switch on the 'Show developers tab in ribbon' under Office button>Excel Options>Personalize

This will give you a new tab on the ribbon
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Extract Comma-Separated Matches Based on Multiple Criteria and Order Preservation
2
Replies
10
Views
188
sobuj53
S
M
  • Solved
Offset select upwards without looping without selecting hidden cells?
2
Replies
11
Views
460
MichaelRSnow
M
R
  • Solved
Generate 1000 Iterations of a Calculated Value
Replies
4
Views
136
Peter_SSs
Peter_SSs
K
  • Solved
last occurrence of a value in a 4 column array
Replies
4
Views
104
kmr47
K
Ramballah
  • Solved
Finding the first certain value with conditions
2
Replies
18
Views
299
mumps
mumps

Forum statistics

Threads
1,215,059
Messages
6,122,918
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top