Hi all, I have been working with LOOKUP formula and ran into small issue and need some expertise help...
The below formula skips a cell if there is a value in it.. in below example my cell starts at M2..however when I have a value there and the formula skips to M3 it picks up values under row 2 (so it takes A2, C2, H2)
Am I missing some $$s here in the formula? Any help would be much appreciated.. thanks so much!
Please Login or Register to view this content.
Last edited by donyc; 02-06-2012 at 08:00 PM.
I realize it might be difficult to understand from my explanation..attaching workbook..hope this helps!.. any help is very much appreciatied. I been working with LOOK UPs all week..and just finishing all the testing now.
thanks again
Try using R1c1 references
(untested but I think I have the columns right)Please Login or Register to view this content.
Good luck.
thank you so much, that does work! I will adjust it for all other ones.. sorry..any idea if it is possible to fix problem #2 in my worksheet? Sorry I broke down the details in the worksheet but realized didnt add 2nd point here.. the issue is:
I want to look up ONLY specific city in my previous day tab. I match my 3 identifiers A,C,H across 2 tabs to pull value from column M.. the problem is, I have many cities in column M.. I only want to apply the formula for "New York"..is the formula flexible enough to do this?
sorry, if this makes no sense, I added simple example in the worksheet..
I don't really follow. If you only want this to apply to US, but still return cities from other countries, then you will need something like
Please Login or Register to view this content.
sorry.. I knew my explanation wasn't the best...I only want to match data in previous day tab column that has ONLY city: "New York" (column M or also defined in formula as: 'previous day'!R8C13:R" & LRDat2 & "C13)))"
So you are not interested in any country other than the United States at all?
thats correct.. Although, I dont want to limit this to country.. I only care about identifier "New York" in column M in my "Previous Day" tab.. then whatever the rows I have in my "Data" tab I compare against ONLY "New York" in "Previous Day" tab by using lookup of 3 identifiers..
fyi - all other columns are not countries/amounts but random ids.. I just use this for simplicity.. New York though is in my actual file and that is what I need
In that case
(untested)Please Login or Register to view this content.
you sir are a genius! thank you thank you! I will implement it across the workbook to test the remaining ones.. thank you so much again for your help with this
Sorry, I am trying to implement in slightly different version of LOOK UP and got stuck.lol.original formula is there, below is how I edited it.. this is the formula I use to tranfer # cells..
Am I missing something here?
this is how I changed it but I think I am missing something?Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks