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.
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...
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 :)
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. :)
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! :)
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 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...
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...
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...