vlookup rates without table , need formula

[makinmomb]

GOMA 480000 250000
KASUMBALESA 480000 250000
KITWE 420000 200000
LUBUMBASHI 480000 250000
LUSAKA 420000 200000
NDOLA 420000 200000

These is the table of rates

I need one formula two pick those rates on b1 and c1 where a1 is location
I dont need this table anywhere else , i need one formula to take
that table , some kind of multipe if lookup

 

[Aladin Akyurek]

I am using excel 2013 , anyone can guess which separator will work , i don't know how
to determine through code

Enter say in X2

=

then select the table you posted, then

hit F9. And delete = from what you see.

You can copy the result of these actions and plug in the VLOOKUP formulas I already suggested.

If done successfully, you can delete the table you have if it is convenient to do so.

 

[makinmomb]

Can anyone do me a macro on this , I am wasting time on the formula and cant make it work

 

[makinmomb]

You cant attache file in here i guess

 

[makinmomb]

someone with a multiple if , I think if can do this work

 

[Aladin Akyurek]

Can anyone do me a macro on this , I am wasting time on the formula and cant make it work

Last effort...

Book1
	A	B	C	D	E
1			GOMA	480000	250000
2	KITWE	420000	KASUMBALESA	480000	250000
3			KITWE	420000	200000
4			LUBUMBASHI	480000	250000
5			LUSAKA	420000	200000
6			NDOLA	420000	200000
Sheet1

In B2 enter:

=VLOOKUP(A2,$C$1:$E$6,2,0)

Now go to the formula on the formula bar, select the $C$1:$E$6 bit, hit F9 followed by enter.

The formula has now a hardcoded table as you wanted. Once done, you can delete C1:E6.

Good luck.

 

[makinmomb]

I need one without table search , if this is this then this , if this cell is this one then this and so on ,
like that grade system a b c and d

 

[makinmomb]

If argument to contain this logic , if cell A1 is goma then 480000 and if kasum... then 480000 , and so on ,
i dont want it a go look a table , i want it do do within one formula

[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64"]GOMA[/TD]
[TD="width: 64, align: right"]480000[/TD]
[/TR]
[TR]
[TD]KASUMBALESA[/TD]
[TD="align: right"]480000[/TD]
[/TR]
[TR]
[TD]KITWE[/TD]
[TD="align: right"]420000[/TD]
[/TR]
[TR]
[TD]LUBUMBASHI[/TD]
[TD="align: right"]480000[/TD]
[/TR]
[TR]
[TD]LUSAKA[/TD]
[TD="align: right"]420000[/TD]
[/TR]
[TR]
[TD]NDOLA[/TD]
[TD="align: right"]420000[/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

It is a simple multiple if with 6 arguments , someone please out there

 

[Dave Patton]

Did you try my suggestion in the post above #9 ?

What Country are you in? What are the Regional Settings for your computer?