Hello.

I have a hopefully simple problem that I hope someone here can answer
for me or lead me in the right direction.

I have a very simple data.xls file that just has 1 sheet with two
columns that contain text. (like a lookup translation table).

Whats the easiest way to query this file looking for "Blah" in ColA and
get the "Foo" from ColB (Using Visual Basic)?

I understand the basics on how top open a file and loop through cells,
but there must be an easier way to quickly query the columns?

Any help is greatly appreciated.

Thanks.


---
Message posted from http://www.ExcelForum.com/

You can even use vlookup without opening the other workbook.

--
Don Guillett
SalesAid Software

"Icemak " wrote in message
...
Hello.

I have a hopefully simple problem that I hope someone here can answer
for me or lead me in the right direction.

I have a very simple data.xls file that just has 1 sheet with two
columns that contain text. (like a lookup translation table).

Whats the easiest way to query this file looking for "Blah" in ColA and
get the "Foo" from ColB (Using Visual Basic)?

I understand the basics on how top open a file and loop through cells,
but there must be an easier way to quickly query the columns?

Any help is greatly appreciated.

Thanks.


---
Message posted from http://www.ExcelForum.com/

Thanks for the start... just cant figure out the named range things..
just wish I could access the whole column.


---
Message posted from http://www.ExcelForum.com/