Vlookup should skip blank cell

[onlypiyush]

Hi,
I have currency codes in coloum A and some numeric values in coloum B.
e.g.

USD 456.00
GBP 1265.00
CHF 6454.00
AUT
USD 534.00
INR 8875.00
RAD
ZAB
CHF 963.00

You would notice that some cells in coloum B are blank. I want vlookup to avoid this blank value and move on to next cell till it finds the value. If there is no value then it should return zero; but that too after checking entire list. Can somebody please help me with this?

Thanks

 

[adam087]

Where are you putting the VLOOKUP?
Do you want it to move to the next column, or the next row?

Adam

 

[onlypiyush]

I want it to move down the row. My criterion is currecy. If not vlookup then suggest another function or macro.

 

[adam087]

Yeah sorry, I still don't understand what you're looking to do. Where is the VLOOKUP forumla going? What are you trying to lookup?

Adam

 

[onlypiyush]

Adam,

My vlookup formula would be as under.

=vlookup(G2;'Sheet2'A1:B6;2;0)

I had only given the range coloum in my 1st thread. My criterion/lookup value would be in sheet 1. So I have predefined currency values in Sheet 1. Now I need to pull the relevant values from Sheet 2. These values would change every month. However my lookup value would remain constant. Hope this clarifies.

Piyush