Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Howdy.
I have a worksheet where each row has several columns with values. I want to take these column values and look up a value from an external database. I also don't want to create a query for each row (since there are many thousands of rows). I know how to get a query to return a value for a single row, but is there a way to get a query to return a value for each row and place the result in a column at the end of the row whose values are being matched. Thanks in advance for your help. Stephen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Querying Large Database | Excel Discussion (Misc queries) | |||
Summing values in a database against certain criteria | Excel Worksheet Functions | |||
SUMIF positive values only from database | Excel Worksheet Functions | |||
How to aggregate values in a database | Excel Worksheet Functions | |||
Querying Access Database | Excel Worksheet Functions |