Your formula for row 3 would look like:

=IF(C3="USD",VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE))

Paul

>
>From: Jagadeesh B S <jagg...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Wed, November 17, 2010 7:45:42 AM
>Subject: $$Excel-Macros$$ Help required for formule
>
>
>Hello Friends
>I need a formula or macro( preferabley formule) need to prepare this report .
>I need a formula which should get the details for the account # mentioned in 
>the 
>column A with the reference to the currency,form the sheet DATA, if the 
>currency 
>is USD It should pull the value in the column E and if the currency is other 
>then USD it should pull the value in the column D.
> 
>Please help with this formula…
> 
>Thanks you very much.:)
>
>-- 
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Reply via email to