Search results

you also can concatenate columns A and B in a separate column in both sheets and do the look up.

Or you have to lock the area from the second sheet. Your data is placed only in A1:B2, so adda $ sign to lock it: =VLOOKUP (A:A;Sheet2!A$1$:$B$2;2;FALSE) Otherwise, you formula starts to take values from B3; B4; B5 and etc. and those cells have no value.

PCosta, I used this one. THANK YOU!

Hi Ninjas, I need an excel formula. I have a feeling it is the easy one but my brains reject to work today. Please find my example file attached. I have different companies which operates in different currencies. I need to translate everything to USD based on the company code, month and FX...

The last line used is 8 in your example. The 9 would be the line to start with probably? But I am following vaios logic in his example. He shows 10 rows filled in and says that 1st line shouldn't be counted. 10-1=9 (his answer). Looking at your example, you filled in 8 rows (2 are blank, but...

Hi deciog, - in your example only 6 rows are used. Why your answer is 9?

if you get the answers there will be no magic....right? :) :)

Bosco, In Shan Li example the first row in the first table (Date 2017.05.07 in A2:E2) matches 2 values from Table 2. It could be row G3:K3 rate 2.90 and G9:K9 rate 2.50). Your formula catches the first value? or the highest value? And actually it is not clear what Shan Li needs in this...

and yes, I stick to my words, BUT...my push button should give me the answer I need for any particular question :). Not the same answer to all my questions :)

hahaha. yes!! exactly! just would be good that computer is able to give me some cash after I find that treasure. :) :) P.S. you are crazy!!

hahahahaha! Made my day! But you missed something in it! After I push 25 times the sentence should appear from those colored cell "Siga, you are the Queen" or smth similar :) :) :) P.S. Still laughing!! P.S. I really hope this will not be the only one solution from you to every question I will...

hahaha. the funniest thing is that this "problem" is Carlos, not mine. But...now you know how to deal with my "problems" in the future! I only need to push button! Only push! and push! and push! THANK YOU and have an easy Wednesday. :)

Yes! It works!

my goodness, vletm! you should sleep instead of solving this alone! Apreciate, but but but... P.S. Polar bears say "hi" to you :)

Carlos gave me an idea, so insetad of opening it, I tried to save to my computer and open from there. It gives the same error, just saying "Run time error '5' this time (not 9).

hahaha. Thank you :) I am a woman - I want to press the button and see the result. If no result - I cry... "what-when" is not something I was created for. hahaha! :)

Yes, Sir.

My computer doesn't show that and I don't know why.

based on Bosco formula below =(LEN(C5)=11)*(LEFT(C5,2)="CM")*ISNUMBER(--RIGHT(C5,9)) for 4 number digits the first part of the formula should be =(LEN(C4)=8) as you have 4 simbols as letters and 4 simbols as numbers: DKE-1449 (total 8) how to make to work 3 and 4 together for numbers - let's...

I am in 2007 Excel. Not sure if this is it, but I do not see any difference while choosing different "views". Hope Carlos is more lucky :)

I know it is not my "problem", but still want to check your miracle, vletm. Anyway, now trying to choose from the drop down meniu I receive a message Run-time error '9' Suscription out of range End Debug Help Choosing Debug it throws me to your macros. Trying to exit, everything dissapears in...

hmm..does it really work? I make a selection, but the view is the same even after enabling the content.

I played a bit for my understanding. If you enter smth different than CM or less numbers than 9, the cell shouts that the value you entered is not valid. A person can't get through in this cell untill he enters CM and 9 numbers. Anyway, for me it is not clear how you will validate if he mixes...

Hi vletm, Don't say you live on the next street :) :) :) Yes, dropdown worked fine! Thank you. Siga

vletm, you are completely wrong, because Siga likes hammock in Grand Cayman Islands :) :) :) and not long formulas! But life is cruel so Siga is in the North Pole hanging with polar bears. what do you mean by not liking yours? I do. but as it is a different sheet and I really do not know how...