use formula result in another formula Or other Proposals

[Hui]

Admin (terrible name by the way)


In CRPO!G4 it should be =H4 not =H4&""


You don't specify columns like:

=IF($G$4="","",VLOOKUP($G$4,badd,MAX(18,19),FALSE))


In B8 I think it should be:

=IF($G$4="","",MAX(INDEX(badd,MATCH(G4,'owssvr (1)'!A2:A1000,0),18),INDEX(badd,MATCH(G4,'owssvr (1)'!A2:A1000,0),19)))

or

=IF($G$4="","",MAX(OFFSET('owssvr (1)'!$A$1,MATCH(G4,'owssvr (1)'!A2:A1000,0),17,1,2)))

I prefer the second version

 

[Hui]

Second part:


I would setup a table of Country and Currency say in CRPO at K4:L25


Country Currency

[pre]

Pakistan	Rup
UK		£
South African	Rand
Australian	A$
Namibia		NAD$
USA		U$
etc

[/pre]
Then in B19:

=INDEX(K5:L25,MATCH(B20,K5:K25,0),2)&" "&Value Reference


Where Value Reference is a reference or lookup to get the salary value

 

[ExcelMan7]

ooh ... you are really amazing ....i can't thank you enough Mr.HUi...10000000 thanks for you....its work fine now...


admin